To get the show notes as well as get notified of new episodes, visit: In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: Timestamps: 00:50 - PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs 06:10 - OpenAI: Scaling PostgreSQL to the Next Level 07:49 - Locks 10:21 - Big Problems From Big IN lists with Ruby on Rails and PostgreSQL 12:44 - Open Data Standards: Postgres, OTel, and Iceberg 15:05 - Backfilling Postgres TOAST Columns in Debezium Data Change Events 16:00 - CloudNativePG and Released! 16:26 - Amazon Aurora DSQL is now generally available 16:58 - Consulting Corner 18:50 - Outro #postgres #postgresql