connection pool

Feb 05

Postgres client_connection_check_interval

Jeremy

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...

linux performance technical postgresql database operations pgbouncer connection pool planet

Jan 20

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

Jeremy

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...

haproxy linux performance golang technical postgresql troubleshooting database operations pgbouncer load balancer connection pool planet pgx