Mitigate Retry Storms? | Scaling Postgres 403

Mitigate Retry Storms? | Scaling Postgres 403

Author: Creston Jamison February 9, 2026 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 get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/403-mitigate-retry-storms/ 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
100 Times Faster By Skipping! | Scaling Postgres 392 [not-audio_url] [/not-audio_url]

Duration: 15:52
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount. To get the show not…
Table Lock Explosion! | Scaling Postgres 391 [not-audio_url] [/not-audio_url]

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 note…
1.2 Million Messages Per Second | Scaling Postgres 390 [not-audio_url] [/not-audio_url]

Duration: 17:32
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning. To get the show notes as well as get notified of new episo…
Heavy Reader or Writer? | Scaling Postgres 389 [not-audio_url] [/not-audio_url]

Duration: 14:21
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement. To get the show…
NVME Wins? | Scaling Postgres 388 [not-audio_url] [/not-audio_url]

Duration: 16:26
In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems? To get…
Boosting Planning Performance | Scaling Postgres 387 [not-audio_url] [/not-audio_url]

Duration: 15:54
In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive solution and we discuss the completion of…
Postgres 18: The Deep Cuts | Scaling Postgres 386 [not-audio_url] [/not-audio_url]

Duration: 15:03
In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart. To get the show…
Postgres 18 Released! | Scaling Postgres 385 [not-audio_url] [/not-audio_url]

Duration: 17:07
In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as not valid and more! To…
Preparing For Postgres 18 | Scaling Postgres 384 [not-audio_url] [/not-audio_url]

Duration: 17:25
In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade. To get the show notes as well as get notified of new epis…
OrioleDB More Free? | Scaling Postgres 383 [not-audio_url] [/not-audio_url]

Duration: 13:20
In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods resolve to slow order by limit queries. To get the show notes as well a…