[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RU-vid's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
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) postgres.fm/ep...
Postgres TV hacking session with Andrey and Kirk: • Hacking Postgres 101 -...
UUIDv7 patch commitfest.pos...
Use ULID Idempotency Keys (tip 6 in this blog post from Shopify) shopify.engine...
Nikolay’s howto post on UUID v7 and partitioning with TimescaleDB gitlab.com/pos...
Hussein Nasser’s RU-vid video about the above • How Shopify’s engineer...
UUID proposal that includes UUIDv7 and UUIDv8 (work in progress): datatracker.ie...
James Blackwood-Sewell advice on more elegant solution using TimescaleDB / 1730125437903450129
ULIDs and Stripe IDs (section of Identity Crisis blog post by Brandur) brandur.org/na...
Crunchy Bridge changed their default random_page_cost to 1.1 🙌 / 1720477470116422028
UUIDs vs serials for keys (newer post from Christophe Pettus) thebuild.com/b...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the uncut version, with video. Check out Postgres.fm to find audio-only podcast episodes, edited for convenient listening.
11 окт 2024