Stable Plans? | Scaling Postgres 407

Stable Plans? | Scaling Postgres 407

Author: Creston Jamison March 9, 2026 Duration: 18:48
In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed clients, on conflict do select and all about Patroni. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/407-stable-plans/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

If you're working with PostgreSQL, you know that growth brings a unique set of challenges. Scaling Postgres, hosted by Creston Jamison, is a weekly resource dedicated to navigating those exact hurdles. This isn't about abstract theory; it's a practical guide focused on extracting the best performance and building a resilient architecture as your data and user demands increase. Each episode serves as curated insight, distilling valuable information from across the web into actionable advice tailored for developers and engineers. The discussion consistently centers on how your specific application design and usage patterns are the fundamental levers for optimization. You'll hear clear explanations on configuration tuning, indexing strategies, replication, and managing bottlenecks-all through the lens of real-world scalability. Tune in to this technology podcast for a focused, developer-centric conversation that helps you build with confidence, ensuring your database infrastructure is robust, efficient, and ready for what's next.
Author: Language: English Episodes: 100

Scaling Postgres
Podcast Episodes
Shard With One Command  | Scaling Postgres 413 [not-audio_url] [/not-audio_url]

Duration: 19:52
In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata going open source, and checkpoints and WAL storms. To get…
Half as Fast on Linux 7  | Scaling Postgres 412 [not-audio_url] [/not-audio_url]

Duration: 15:31
In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing in Postgres and WAL to distribute data. To get the show notes as well as get noti…
Absorbing Load | Scaling Postgres 411 [not-audio_url] [/not-audio_url]

Duration: 19:55
In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and plan_cache_mode. To get the show notes as well as get notified of new epi…
Postgres Traffic Cop! | Scaling Postgres 410 [not-audio_url] [/not-audio_url]

Duration: 12:12
In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB schema migration survey and a new repack command. To get the show notes…
Iceberg Causes Postgres Acquisitions? | Scaling Postgres 409 [not-audio_url] [/not-audio_url]

Duration: 14:07
In this episode of Scaling Postgres, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNativePG & query tuning, setting up Patroni and utilizing PgBouncer. To get the sho…
Open Source Eating The World | Scaling Postgres 408 [not-audio_url] [/not-audio_url]

Duration: 17:05
In this episode of Scaling Postgres, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, and how work_mem is a trap. To get the show notes as well as get notified of new e…
Lock Causes Data To Vanish! | Scaling Postgres 406 [not-audio_url] [/not-audio_url]

Duration: 18:21
In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling. To get the show notes as well as get notified of new…
Out of Cycle Releases | Scaling Postgres 405 [not-audio_url] [/not-audio_url]

Duration: 16:59
In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how to maintain reading efficiency. To get the show notes as well as get notifi…
Postmaster Does Not Scale! | Scaling Postgres 404 [not-audio_url] [/not-audio_url]

Duration: 17:21
In this episode of Scaling Postgres, we discuss how the postmaster does not scale, new Postgres releases, data storage using PAX and a path generation strategies change. To get the show notes as well as get notified of n…
Mitigate Retry Storms? | Scaling Postgres 403 [not-audio_url] [/not-audio_url]

Duration: 16:22
In this episode of Scaling Postgres, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_interval, checkpoint configuration, skip scans and more just use Postgres. To ge…