We Scale PgBouncer in ClickHouse Managed Postgres
ClickHouse Managed Postgres has scaled PgBouncer, the PostgreSQL connection pooler, to improve connection management and performance for its users. The scaling effort enhances the handling of high volumes of database connections, reducing overhead and improving reliability. This update aims to optimize resource usage in ClickHouse's managed PostgreSQL service.
Background
ClickHouse is a real-time analytics database company (not to be confused with ClickHouse the open-source project, though they are related). PgBouncer is a popular open-source connection pooler for PostgreSQL that sits between applications and the database, reusing connections to handle many clients efficiently. In managed (cloud-hosted) PostgreSQL services, scaling PgBouncer is a known operational challenge because it's easy to misconfigure or run into resource limits. ClickHouse's post describes how they tuned and scaled PgBouncer in their own managed Postgres offering, which is relevant for anyone running Postgres at scale—especially teams using connection pooling to avoid performance bottlenecks.