4 Times Faster UUID Primary Keys | Scaling Postgres 368

Scaling Postgres · 2025-06-01

19:10

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.

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/368-4-times-faster-uuid-primary-keys/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Scaling Postgres

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.

No. of episodes: 370

Latest episode: 2025-06-15

Technology

Where can you listen?

Episodes