Scaling Postgres

Hosted by Creston Jamison

Technology

Website RSS feed

Episodes

439

Latest episode

Oct 2026

Language

About the show

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.

Listen to episodes

60 recent

October 25, 202615 min

10 Million QPS . . . Efficiently | Scaling Postgres 440

In this episode of Scaling Postgres, we discuss how to reach 10 million queries per second efficiently, Postgres performance on GPUs, the next release of pgrust and not trusting ON DELETE CASCADE. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/440-10-million-qps-efficiently/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

October 18, 202616 min

Text Search Battle Royale! | Scaling Postgres 439

In this episode of Scaling Postgres, we review two companies battling one another for text search dominance in Postgres, faster vector search with pg_vectorsearch, pushing Citus scaling with query routers and PostgreSQL 19 RC1 is released. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/439-text-search-battle-royale/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

October 11, 202611 min

Competition Is Good | Scaling Postgres 438

In this episode of Scaling Postgres, we discuss performance improvements in ParadeDB as a result of PlanetScale, an open source BM25 index from PGX Inc., pgbouncer and pgvector patching and direct I/O benefits during backup. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/438-competition-is-good/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

October 4, 202616 min

The Reason For Reversions | Scaling Postgres 437

In this episode of Scaling Postgres, we discuss the reasons for all the PG 19 reversions, why open source wins, the cost of REPACK CONCURRENTLY and hint implementations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/437-reason-for-reversions/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

September 27, 202612 min

Postgres 19 Beta 4 Released! | Scaling Postgres 436

In this episode of Scaling Postgres, we discuss PG19 Beta 4, pgBouncer CVEs, managed provider security and transferring data to Clickhouse using physical replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/436-postgres-19-beta-4-released/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

September 20, 202610 min

Postgres 19 Revert Train! | Scaling Postgres 435

In this episode of Scaling Postgres, we discuss possibly twelve different feature reversions in Postgres 19 and why, the impact of one more index, the cost of a single insert and Neki is released. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/435-postgres-19-revert-train/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

September 13, 202611 min

Postgres 19 Reversions | Scaling Postgres 434

In this episode of Scaling Postgres, we discuss various reversions and the uncertain release date of Postgres 19, pgSafe a new backup solution written in Go, inserting state transitions and an operator that supports logical replicas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/434-postgres-19-reversions/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

September 6, 202616 min

Read After Write | Scaling Postgres 433

In this episode of Scaling Postgres, we see examples of using WAIT FOR in PG 19 for handling read after write, local NVME vs block store, new system views and the ambiguity of NULL. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/433-read-after-write/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

August 30, 202615 min

23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432

In this episode of Scaling Postgres, we discuss getting 23 times faster inserts with UUIDv7, the benefits and downsides of UUIDs, how to optimize queries without table changes and using WAIT FOR to read your writes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/432-23-times-faster-inserts-with-uuidv7/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

August 23, 202611 min

pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431

In this episode of Scaling Postgres, we cover postgres.fm's interview of pgrust co-creator Michael Malis, pgDog vs RDS Proxy, Postgres on Kubernetes in 10 minutes and evolution to Postgres 19. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/431-pgrust-co-creator-postgresfm-interview/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/