High-performance connection pooling solutions designed to manage thousands of concurrent client connections for PostgreSQL databases.
PgBouncer is a lightweight middleware proxy server and connection pooler for PostgreSQL. It acts as a database connection manager and load balancer, reducing system overhead by managing a pool of reusable connections and distributing incoming traffic across multiple backend servers. The project distinguishes itself through a protocol-level proxying approach that handles authentication and TLS encryption without parsing underlying SQL queries. It provides specialized support for mapping named prepared statements across different backend connections and implements a socket-sharing process model
PgBouncer is the established lightweight PostgreSQL connection pooler and proxy server, purpose-built to handle thousands of concurrent clients with transaction pooling, prepared statement caching, and low overhead — it directly matches every required feature for scaling PostgreSQL connections.