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
DB LLM Agents? | Scaling Postgres 382 [not-audio_url] [/not-audio_url]

Duration: 19:03
In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a blue/green rollback. To get the show notes as we…
DocumentDB Movement | Scaling Postgres 381 [not-audio_url] [/not-audio_url]

Duration: 9:44
In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities. To get the show notes as well as get notified of new episodes, v…
Storage Engine Progress? | Scaling Postgres 380 [not-audio_url] [/not-audio_url]

Duration: 14:53
In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations. To get the show notes as well as get notified of new episodes, vis…
Unconventional Advice? | Scaling Postgres 379 [not-audio_url] [/not-audio_url]

Duration: 19:03
In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing performance optimizations. To get the show notes as…
Native Column Store? | Scaling Postgres 378 [not-audio_url] [/not-audio_url]

Duration: 19:29
In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive. To get the show notes as we…
Sharding At Network Speeds | Scaling Postgres 377 [not-audio_url] [/not-audio_url]

Duration: 15:14
In this episode of Scaling Postgres, we discuss how to shard your DB at network speeds, how to make your DB 42,000 slower, new monitoring and just enough text searching performance. To get the show notes as well as get n…
100K Events Per Second Queue | Scaling Postgres 376 [not-audio_url] [/not-audio_url]

Duration: 19:45
In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXact ID and space overrun and struggles starting Postgres. To get the show notes a…
All The Benchmarks | Scaling Postgres 375 [not-audio_url] [/not-audio_url]

Duration: 16:19
In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and a deep dive into Multigres. To get the show notes as well as get noti…
Migrating Millions Of Databases | Scaling Postgres 374 [not-audio_url] [/not-audio_url]

Duration: 18:34
In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication slots. To get the show notes as well as get not…
Planetscale Postgres! | Scaling Postgres 373 [not-audio_url] [/not-audio_url]

Duration: 14:22
In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are optimal, avoiding UUIDv4 and the summer of upgrade report. To get the show note…