Partitioning by ULID

Nikolay and Michael discuss partitioning by ULID — revisiting some of the old UUID vs bigint key debate in light of some new UUID specs, and how these can be used for partitioning (by time). 
 
Here are some links to things they mentioned:

• Nikolay’s episode on UUID (for primary keys) https://postgres.fm/episodes/uuid 
• Postgres TV hacking session with Andrey and Kirk: https://www.youtube.com/watch?v=YPq_hiOE-N8
• UUIDv7 patch https://commitfest.postgresql.org/43/4388/ 
• Use ULID Idempotency Keys (tip 6 in this blog post from Shopify) https://shopify.engineering/building-resilient-payment-systems 
• Nikolay’s howto post on …

databases postgres postgresql sql technology