How to partition Postgres tables by timestamp based UUIDs

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-partition-tables-time-based-UUID 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 https://twitter.com/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/partitioning-postgres-tables-by-timestamp-based-uuids/60916 *HackerNews thread about Chris’ article* https://news.ycombinator.com/item?id=38965965 *UUID v7 on postgresql.org mailing list* https://www.postgresql.org/message-id/flat/CAAhFRxitJv=yoGnXUgeLB_O+M7J2BJAmb5jqAT9gZ3bij3uLDA@mail.gmail.com *UUID v7 timeline* https://datatracker.ietf.org/doc/draft-ietf-uuidrev-rfc4122bis/ *Current queue for UUID v7 on RFC-editor.org* https://www.rfc-editor.org/current_queue.php#draft-ietf-uuidrev-rfc4122bis *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-postgres-uuid-vs-serial-primary-keys *Partition pruning, prepared statements and generic vs custom query plans* https://pganalyze.com/blog/5mins-postgres-partition-pruning-prepared-statements-generic-vs-custom-query-plans