connection pool

This tag is associated with 2 posts

Postgres client_connection_check_interval

Posted by Jeremy ⋅ February 4, 2026 ⋅ Leave a comment

Saw this post on LinkedIn yesterday: I also somehow missed this setting for years. And it’s crazy timing, because it’s right after I published a blog about seeing the exact problem this solves. In my blog post I mentioned “unexpected behaviors (bugs?) in… Postgres itself.” Turns out Postgres already has the fix; it’s just disabled … Continue reading →

How Blocking-Lock Brownouts Can Escalate from Row-Level to Complete System Outages

Posted by Jeremy ⋅ January 19, 2026 ⋅ Leave a comment

This article is a shortened version. For the full writeup, go to https://github.com/ardentperf/pg-idle-test/tree/main/conn_exhaustion This test suite demonstrates a failure mode when application bugs which poison connection pools collide with PgBouncers that are missing peer config and positioned behind a load balancer. PgBouncer’s peering feature (added with v1.19 in 2023) should be configured if multiple PgBouncers are being used … Continue reading →