Table Lock Explosion! | Scaling Postgres 391

Table Lock Explosion! | Scaling Postgres 391

Author: Creston Jamison November 10, 2025 Duration: 19:15
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an upcoming sale on my course. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/391-table-lock-explosion/ 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
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329 [not-audio_url] [/not-audio_url]

Duration: 19:01
In this episode of Scaling Postgres, we discuss PGlite, an embeddable Postgres, postgres.new which adds AI features, new Postgres releases and the performance of synchronous replication. To get the show notes as well as…
Implement Get Or Create | Scaling Postgres 328 [not-audio_url] [/not-audio_url]

Duration: 16:10
In this episode of Scaling Postgres, we discuss different get or create implementations, a new pgBouncer version, alter default privileges, and six degrees of separation with Postgres. To get the show notes as well as ge…
Postgres Graph Queries | Scaling Postgres 327 [not-audio_url] [/not-audio_url]

Duration: 16:30
In this episode of Scaling Postgres, we discuss using Postgres for graph queries, the fastest way to copy data from one table to another, dealing with linux memory overcommit and compression. To get the show notes as wel…
Faster Index Creation | Scaling Postgres 326 [not-audio_url] [/not-audio_url]

Duration: 20:28
In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and savepoints. To get the show notes as well as get notified of new episo…
Faster Paging? | Scaling Postgres 325 [not-audio_url] [/not-audio_url]

Duration: 20:07
In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL functions, how expensive extended statistics are and the benefits of range c…
Four Million TPS | Scaling Postgres 324 [not-audio_url] [/not-audio_url]

Duration: 16:29
In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, parallelism in Postgres and an introduction to window functions. To get t…
PgBouncer Breaking Change | Scaling Postgres 323 [not-audio_url] [/not-audio_url]

Duration: 23:47
In this episode of Scaling Postgres, we discuss a breaking change in the new version of PgBouncer, PostgreSQL 17 Beta 2 is released, examination of the new built-in collation provider in PG 17 and Notion's data lake. To…
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…

«1...678910