Scaling Postgres

Scaling Postgres

Creston Jamison
Country USA
Genres Technology
Language EN
Episodes 425
Latest 15.11.2026

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.

Episodes

  • Postgres Releases & 52 Security Fixes | Scaling Postgres 443
    Postgres Releases & 52 Security Fixes | Scaling Postgres 443 15.11.2026 17m
    In this episode of Scaling Postgres, we discuss new Postgres minor releases that patch 52(!) vulnerabilities, the AI impact on Postgres, pgrust progress, and handling extensions in containers. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/443-postgres-releases-52-security-fixes/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • Bare Metal Speed Postgres? | Scaling Postgres 442
    Bare Metal Speed Postgres? | Scaling Postgres 442 08.11.2026 17m
    In this episode of Scaling Postgres, we discuss the public beta of Oriole DB, 100,000 times faster queries with GPUs, post pg_restore to-do and a lesson in data integrity. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/442-bare-metal-speed-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • 100K Faster Queries With GPUs! | Scaling Postgres 441
    100K Faster Queries With GPUs! | Scaling Postgres 441 01.11.2026 19m
    In this episode of Scaling Postgres, we discuss the public beta of Oriole DB, 100,000 times faster queries with GPUs, post pg_restore to-do and a lesson in data integrity. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/441-100k-faster-queries-with-gpus/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • 10 Million QPS . . . Efficiently | Scaling Postgres 440
    10 Million QPS . . . Efficiently | Scaling Postgres 440 25.10.2026 15m
    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/
  • Text Search Battle Royale! | Scaling Postgres 439
    Text Search Battle Royale! | Scaling Postgres 439 18.10.2026 16m
    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/
  • Competition Is Good | Scaling Postgres 438
    Competition Is Good | Scaling Postgres 438 11.10.2026 11m
    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/
  • The Reason For Reversions | Scaling Postgres 437
    The Reason For Reversions | Scaling Postgres 437 04.10.2026 16m
    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/
  • Postgres 19 Beta 4 Released! | Scaling Postgres 436
    Postgres 19 Beta 4 Released! | Scaling Postgres 436 27.09.2026 12m
    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/
  • Postgres 19 Revert Train! | Scaling Postgres 435
    Postgres 19 Revert Train! | Scaling Postgres 435 20.09.2026 10m
    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/
  • Postgres 19 Reversions | Scaling Postgres 434
    Postgres 19 Reversions | Scaling Postgres 434 13.09.2026 11m
    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/
  • Read After Write | Scaling Postgres 433
    Read After Write | Scaling Postgres 433 06.09.2026 16m
    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/
  • 23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432
    23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432 30.08.2026 15m
    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/
  • pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431
    pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431 23.08.2026 11m
    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/
  • 28 Security Vulnerabilities | Scaling Postgres 430
    28 Security Vulnerabilities | Scaling Postgres 430 16.08.2026 10m
    In this episode of Scaling Postgres, we discuss new releases fixing 28 security vulnerabilities, more MVCC, BYOK encryption and should Postgres include pgbouncer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/430-28-security-vulnerabilities/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • 300 Times Faster Analytics With pgrust | Scaling Postgres 429
    300 Times Faster Analytics With pgrust | Scaling Postgres 429 09.08.2026 13m
    In this episode of Scaling Postgres, we discuss pgrust running analytical queries 300 times faster than Postgres, how to speed up distinct count, Xata podcast and massively parallel backups. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/429-300-times-faster-analytics-with-pgrust/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • Postgres MVCC Is Bad? | Scaling Postgres 428
    Postgres MVCC Is Bad? | Scaling Postgres 428 02.08.2026 17m
    In this episode of Scaling Postgres, we discuss how bad Postgres MVCC is, a startup's survival guide for Postgres, an examination of DBOS, and different ways of performing hybrid searches. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/428-postgres-mvcc-is-bad/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • Migrating to pg_hardstorage | Scaling Postgres 427
    Migrating to pg_hardstorage | Scaling Postgres 427 26.07.2026 8m
    In this episode of Scaling Postgres, we discuss migrating to pg_hardstorage for Postgres backup, PG 19 Beta 2 is released, collecting log stats with pg_stat_log and PG 19 checkpoint additions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/427-migrating-to-pg_hardstorage/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • pgrust Faster Than Postgres? | Scaling Postgres 426
    pgrust Faster Than Postgres? | Scaling Postgres 426 19.07.2026 15m
    In this episode of Scaling Postgres, we discuss the progress of the Rust rewrite of Postgres called pgrust, more about the backup tool pg_hardstorage, beware listen / notify and how to fix bad SQL. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/426-pgrust-faster-than-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • Novel Partition Exclusion | Scaling Postgres 425
    Novel Partition Exclusion | Scaling Postgres 425 12.07.2026 17m
    In this episode of Scaling Postgres, we discuss excluding partitions without using a partition key, a pgBackRest interview, Postgres backup without an incremental chain and a replication deadlock bug in Postgres 14-16. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/425-novel-partition-exclusion/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
  • Too Many Table Danger | Scaling Postgres 424
    Too Many Table Danger | Scaling Postgres 424 05.07.2026 15m
    In this episode of Scaling Postgres, we discuss the dangers of too many tables, don't worry about extending checkpoint_timeout, a disaster recovery process, and non-repeatable sums with floating point numbers. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/424-too-many-table-danger/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Popular in

The podcast also appears in the podcast charts of these countries.