EPISODE · Jun 1, 2026 · 8 MIN
Why Database Connection Pools Need Pool Tuning
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations · host Fexingo
In this episode, Lucas and Luna dive into the often-overlooked art of tuning database connection pools. They explore why default pool settings can lead to performance bottlenecks, using the example of a fintech app that faced latency spikes during peak trading hours. Lucas explains how adjusting minimum and maximum pool sizes, connection timeout, and idle timeout transformed the app's throughput from 200 to 800 transactions per second. The hosts discuss real-world trade-offs, including the risk of connection leaks and the impact of database connection limits. Luna shares a cautionary tale from a friend at an e-commerce company where an untuned pool caused a site-wide outage on Black Friday. The episode concludes with practical tuning guidelines and a reminder that pool tuning is an ongoing process, not a one-time setup. #DatabaseConnectionPools #PoolTuning #DatabasePerformance #ConnectionPooling #FintechApp #BlackFridayOutage #ConnectionLeaks #DatabaseBottlenecks #TransactionThroughput #MaxPoolSize #IdleTimeout #ConnectionTimeout #BackendOptimization #Technology #SoftwareEngineering #FexingoBusiness #BusinessPodcast #DatabaseTechWithFexingo Keep every episode free: buymeacoffee.com/fexingo
What this episode covers
In this episode, Lucas and Luna dive into the often-overlooked art of tuning database connection pools. They explore why default pool settings can lead to performance bottlenecks, using the example of a fintech app that faced latency spikes during peak trading hours. Lucas explains how adjusting minimum and maximum pool sizes, connection timeout, and idle timeout transformed the app's throughput from 200 to 800 transactions per second. The hosts discuss real-world trade-offs, including the risk of connection leaks and the impact of database connection limits. Luna shares a cautionary tale from a friend at an e-commerce company where an untuned pool caused a site-wide outage on Black Friday. The episode concludes with practical tuning guidelines and a reminder that pool tuning is an ongoing process, not a one-time setup. #DatabaseConnectionPools #PoolTuning #DatabasePerformance #ConnectionPooling #FintechApp #BlackFridayOutage #ConnectionLeaks #DatabaseBottlenecks #TransactionThroughput #MaxPoolSize #IdleTimeout #ConnectionTimeout #BackendOptimization #Technology #SoftwareEngineering #FexingoBusiness #BusinessPodcast #DatabaseTechWithFexingo Keep every episode free: buymeacoffee.com/fexingo
NOW PLAYING
Why Database Connection Pools Need Pool Tuning
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m