The Problem With Randomly Distributed UEID

Lonely Nikolay discusses the performance aspects of using UUID for primary keys. 

Here are links to a few things I mentioned: 

• "postgresql" posts on HN, most popular last week (Algolia search): https://hn.algolia.com/?dateRange=pastWeek&page=0&prefix=true&query=postgresql&sort=byPopularity&type=story
• Unexpected downsides of UUID keys in PostgreSQL (a post by Ants Aasma, Cybertec): https://www.cybertec-postgresql.com/en/unexpected-downsides-of-uuid-keys-in-postgresql/
• HN discussion of that post: https://news.ycombinator.com/item?id=36429986
• Additional math by me (converting to bytes): https://twitter.com/samokhvalov/status/1671962111092850689
• Updated RFC4122 (proposal): https://github.com/ietf-wg-uuidrev/rfc4122bis
• Status of that proposal: https://datatracker.ietf.org/doc/draft-ietf-uuidrev-rfc4122bis/history/
• Patch UUID v7 (commitfest record): https://commitfest.postgresql.org/43/4388/
• Postgres hacking with Andrey and Kirk: https://www.youtube.com/watch?v=YPq_hiOE-N8 (where that patch was developed)

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

If you would like to share this episode, here's a good link (and thank you!)

~~~

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork