EPISODE · May 26, 2026 · 13 MIN
Why Database Connection Pools Fail at Scale
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations · host Fexingo
Episode 12 of Database Tech with Fexingo dives into a silent killer of production databases: connection pool starvation. Lucas and Luna walk through a real incident at a mid-sized fintech startup — we'll call it 'PulsePay' — where a perfectly normal pool of 200 connections collapsed under a 3x traffic spike. They explain the math behind pool sizing, the tragedy of the commons when multiple services share one pool, and why connection latency is more dangerous than query latency. You'll learn why 'just increase the pool size' is often the wrong answer, and how tools like PgBouncer and ProxySQL can help — when configured correctly. No theory without teeth: concrete numbers, a real outage timeline, and a fix that cost zero dollars. #DatabaseConnectionPooling #PostgreSQL #PgBouncer #ProxySQL #BackendEngineering #Scalability #ProductionOutage #TechPodcast #DatabaseTech #ConnectionPool #Fintech #SystemDesign #SiteReliability #SQL #NoSQL #FexingoBusiness #BusinessPodcast #Technology Keep every episode free: buymeacoffee.com/fexingo
What this episode covers
Episode 12 of Database Tech with Fexingo dives into a silent killer of production databases: connection pool starvation. Lucas and Luna walk through a real incident at a mid-sized fintech startup — we'll call it 'PulsePay' — where a perfectly normal pool of 200 connections collapsed under a 3x traffic spike. They explain the math behind pool sizing, the tragedy of the commons when multiple services share one pool, and why connection latency is more dangerous than query latency. You'll learn why 'just increase the pool size' is often the wrong answer, and how tools like PgBouncer and ProxySQL can help — when configured correctly. No theory without teeth: concrete numbers, a real outage timeline, and a fix that cost zero dollars. #DatabaseConnectionPooling #PostgreSQL #PgBouncer #ProxySQL #BackendEngineering #Scalability #ProductionOutage #TechPodcast #DatabaseTech #ConnectionPool #Fintech #SystemDesign #SiteReliability #SQL #NoSQL #FexingoBusiness #BusinessPodcast #Technology Keep every episode free: buymeacoffee.com/fexingo
NOW PLAYING
Why Database Connection Pools Fail at Scale
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m