4 Times Faster UUID Primary Keys | Scaling Postgres 368
Join Over 1,000 Engineers & Get New Episodes Weekly!
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.
Content Discussed
- PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs
- OpenAI: Scaling PostgreSQL to the Next Level
- Locks
- Big Problems From Big IN lists with Ruby on Rails and PostgreSQL
- Open Data Standards: Postgres, OTel, and Iceberg
- Backfilling Postgres TOAST Columns in Debezium Data Change Events
- CloudNativePG 1.26.0 and 1.25.2 Released!
- Amazon Aurora DSQL is now generally available
- Advanced Patch Feedback Session (APFS) at pgconf.dev 2025
- Adventures in Extension Packaging
- Debugging memory leaks in Postgres, heaptrack edition
- The Difference Between Postgres Logging and PGAudit
- Collation Torture Test versus Debian
- Using Postgres pg_test_fsync tool for testing low latency writes
- PostgreSQL Europe Diversity Task Force (Deep Dive and Updates)
- Dirk Krautschick
- How to Build Postgres with Zig: A Drop-In GCC/Clang Alternative
- How to Run CRON Jobs in Postgres Without Extra Infrastructure
- PgPedia Week, 2025-05-25
- Contributions for the week of 2025-05-19 (Weeks 20/21 overview)
- Prairie Postgres Developers Summit
- Community Summit at PGConf.dev
- Postgres Extensions Day 2025 Kicks Off with a Successful Debut in Montréal
- pgroll v0.13.0: Start using pgroll on existing databases with the new baseline feature
- Meet the CYBERTEC Migrator
- Recreating S3 in Postgres using PostgREST
- Two New Features in EDB Failover Manager 5.0
- Escaping the AWS RDS Cost Spiral
- Getting started with ElectricSQL and Neon
- Build an AI-powered knowledge base chatbot using n8n and Neon Postgres
YouTube Video
Podcast Audio
