37 subscribers
התחל במצב לא מקוון עם האפליקציה Player FM !
UUID
Manage episode 366900086 series 3369151
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
146 פרקים
Manage episode 366900086 series 3369151
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
146 פרקים
כל הפרקים
×






1 pg_stat_statements track_planning 37:55


ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.