Why pool
DB connections expensive (memory, TCP). Postgres process-per-connection = OS load. Cap concurrent = predictable performance.
Advertisement
PgBouncer
Lightweight Postgres pooler. Session, transaction, statement pooling modes. Transaction mode most common.
Advertisement
Pgcat
Rust-based. Load balancing across primary/replicas. Query routing. Modern PgBouncer alternative.