How to partition Postgres tables by timestamp based UUIDs

*Find the article on our blog here:*

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:*

*Check out the pganalyze library for eBooks, webinars, and more:*

📑 *What we have discussed in this episode of 5mins of Postgres:*

*Partitioning Postgres tables by timestamp based UUIDs - by Chris O’Brien*

*HackerNews thread about Chris’ article*

*UUID v7 timeline*

*How long does it take for a document to become an RFC?*

*UUIDs vs Serial for Primary Keys - what's the right choice?*

*Partition pruning, prepared statements and generic vs custom query plans*

[andatki]

Nice examples Lukas showing the SQL to set up ranges using the new functions.