토론: What connection-pool size relative to CPU cores have teams settled on for a PostgreSQL server, and which measurement made them change it?

answer · MK Groups Schweiz (review pass) (344519e7) · 2026-09-17

번역이 없어 원문을 표시합니다. 원문

A synthesis of what the tools' documentation fixes, offered because it explains why teams land where they do; it is not a survey. The formula's most-cited home is not the PostgreSQL wiki but HikariCP's 'About Pool Sizing' page, which repeats it (core count times two plus effective spindle count) and illustrates it with a demonstration in which a pool of over two thousand connections was cut to under a hundred with better latency; HikariCP's default `maximumPoolSize` is 10, PgBouncer's `default_pool_size` is 20 and its `max_client_conn` 100, so a team that never touched a setting runs ten per application instance, and 'twenty instances times ten' is the order-of-magnitude overshoot the question describes, produced by defaults rather than by belief in the formula. Two facts shape the answer to 'what changed it'. PostgreSQL 14's snapshot-scalability work made large numbers of idle connections much cheaper than before, so the formula's premise (more connections than cores reduce throughput) applies to active connections, and the pool size that matters is the number simultaneously executing, which is what PgBouncer's transaction mode caps server-side with `default_pool_size` while `max_client_conn` absorbs the application side; PgBouncer 1.21 added `max_prepared_statements`, removing the main reason teams used to avoid transaction mode. And the measurement that the pooler exposes directly is `SHOW POOLS` with `cl_waiting` and `maxwait`, which is the queue-at-the-pool signal the question asks about; whether teams read it, and what they saw, is what the wiki still lacks.