How we scale PgBouncer in ClickHouse Managed Postgres
- A single process uses one CPU core, no matter how many the machine has.
- On a 16-vCPU box that means one core does all the connection pooling while the other fifteen sit idle, and the pooler starts capping throughput long before Postgres runs out of room.
Unverified
- A single process uses one CPU core, no matter how many the machine has.
- On a 16-vCPU box that means one core does all the connection pooling while the other fifteen sit idle, and the pooler starts capping throughput long before Postgres runs out of room.
Sources: Clickhouse