How to partition Postgres tables by timestamp based UUIDs
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
In today’s E98 of “5mins of Postgres” we're going to talk about partitioning Postgres tables by timestamp based UUIDs. We're also going to talk about the status of UUIDv7 in the current Postgres development branch. We have a look at Chris O'Brien's great write-up on how to do time-based partitioning with ULID, and are quite excited about being able to do the same with the upcoming UUIDv7.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
Partitioning Postgres tables by timestamp based UUIDs - by Chris O’Brien
https://elixirforum.com/t/partitionin...
HackerNews thread about Chris’ article
https://news.ycombinator.com/item?id=...
UUID v7 on postgresql.org mailing list
https://www.postgresql.org/message-id...
UUID v7 timeline
https://datatracker.ietf.org/doc/draf...
Current queue for UUID v7 on RFC-editor.org
https://www.rfc-editor.org/current_qu...
How long does it take for a document to become an RFC?
https://www.rfc-editor.org/faq/#howlong
UUIDs vs Serial for Primary Keys - what's the right choice?
https://pganalyze.com/blog/5mins-post...
Partition pruning, prepared statements and generic vs custom query plans
https://pganalyze.com/blog/5mins-post...