UUID

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 …