10 min read
Switching PgBouncer to transaction pooling tripled our connection efficiency and broke prepared statements, SET commands, and advisory locks all at once. The fix starts with understanding what a pooled connection no longer guarantees.
PostgreSQL Topic Archive
Connections and Pooling PostgreSQL Articles
Connection storms, pool saturation, PgBouncer behavior, and max_connections pressure.
10 min read
Not every PostgreSQL performance incident is a bad query. Too many connections, idle transactions, pool starvation, and client backpressure can make normal SQL look slow.
6 min read
Connection storms look like database outages but usually start in pools, retries, autoscaling, deploys, and health checks. The fix is shaping pressure before it reaches Postgres.
12 min read
Pooling is about protecting Postgres from connection shape, not just increasing throughput. The hard parts are transaction mode, prepared statements, bursts, and failure behavior.
6 min read
SSL on Postgres is a one-line config change to enable and a multi-day project to do correctly. The default settings are not good enough.
6 min read
Most Postgres connection strings live in places they should not. Environment variables, config files, scripts, screenshots in Slack. Here is the discipline.