pgbouncer

This article explains the problem of poisoned connection pools in PostgreSQL when using PgBouncer, where stale session state can cause write errors, and provides a solution using DISCARD ALL to reset connections.

A developer reflects on a decade-old article about Postgres connection management, surveys popular managed Postgres providers, and argues that PgBouncer-style connection pooling is effectively a mandatory core feature.

ClickHouse Managed Postgres scales PgBouncer to 4x throughput by running a fleet of processes with SO_REUSEPORT, enabling multi-core utilization and solving cancellation forwarding via peering.

A detailed technical guide explaining how PgBouncer works as a PostgreSQL connection pooler, covering its pooling modes, production deployment, and common pitfalls.