Lock Causes Data To Vanish! | Scaling Postgres 406

Lock Causes Data To Vanish! | Scaling Postgres 406

Author: Creston Jamison March 2, 2026 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 episodes, visit: https://www.scalingpostgres.com/episodes/406-lock-causes-data-to-vanish/ 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
Postgres Sort Instability? | Scaling Postgres 322 [not-audio_url] [/not-audio_url]

Duration: 19:48
In this episode of Scaling Postgres, we discuss an incremental sort instability issue with the Postgres planner, whether we should use foreign keys, how the visibility map works and how to vacuum the template0 database.…
Ottertune Is Dead! | Scaling Postgres 321 [not-audio_url] [/not-audio_url]

Duration: 11:02
In this episode of Scaling Postgres, we discuss the shutdown of Ottertune, how schema changes cause locks and how to avoid them, the benefits of on conflic do nothing, and pgvectorscale. To get the show notes as well as…
100 TB and Beyond! | Scaling Postgres 320 [not-audio_url] [/not-audio_url]

Duration: 17:32
In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions To get the show notes as well as get notified of…
When Postgres Development Stopped! | Scaling Postgres 319 [not-audio_url] [/not-audio_url]

Duration: 12:05
In this episode of Scaling Postgres, we discuss a time when Postgres development stopped, two new extensions pg_lakehouse & pg_compare and the upcoming event Posette. To get the show notes as well as get notified of new…
Postgres 17 Beta 1 Released | Scaling Postgres 318 [not-audio_url] [/not-audio_url]

Duration: 17:54
In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it, database collations & sorting and causes of slow commits. To get the show notes as well as g…
Time-Series Open Source Extension | Scaling Postgres 317 [not-audio_url] [/not-audio_url]

Duration: 14:56
In this episode of Scaling Postgres, we discuss a new time-series open source extension called pg_timeseries, Postgres ignoring indexes, JSONB selectivity issues, and geographically distributed multi-tenant applications.…
New Releases & 1,000 Times Faster Query | Scaling Postgres 316 [not-audio_url] [/not-audio_url]

Duration: 14:34
In this episode of Scaling Postgres, we discuss new Postgres releases, optimizing a query to be 1,000 times faster, custom vs. generic plans and the pgtt extension. To get the show notes as well as get notified of new ep…
Hacking On Postgres is Hard! | Scaling Postgres 315 [not-audio_url] [/not-audio_url]

Duration: 19:31
In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics and saturated arithmetic. To get the show notes as well as get not…
150 Times Faster pgvector? | Scaling Postgres 314 [not-audio_url] [/not-audio_url]

Duration: 16:30
In this episode of Scaling Postgres, we discuss performance improvements for pgvector 0.7.0, a guide to vector embeddings, building a Retrieval Augmented Generation app and only allow logins to replicas. To get the show…

«1...678910