UUID | Postgres.FM 051 | LIVE episode
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=pas...
Unexpected downsides of UUID keys in PostgreSQL (a post by Ants Aasma, Cybertec): https://www.cybertec-postgresql.com/e...
HN discussion of that post: https://news.ycombinator.com/item?id=...
Additional math by me (converting to bytes): / 1671962111092850689
Updated RFC4122 (proposal): https://github.com/ietf-wg-uuidrev/rf...
Status of that proposal: https://datatracker.ietf.org/doc/draf...
Patch UUID v7 (commitfest record): https://commitfest.postgresql.org/43/...
Postgres hacking with Andrey and Kirk, a Postgres.TV session: • Hacking Postgres 101 - ULID function (where that patch was developed)