Take the 2-minute tour ×  Is there a rule or something I can use
to calculate a good number for max_connections,
default_pool_size and max_client_conn?  The defaults are odd.
PostgreSQL defaults to max_connections=100 while pgbouncer
defaults to default_pool_size=20. Shouldn't default_pool_size
always be higher than max_connections? Otherwise, what's the
point? I thought pgbouncer was meant to let us handle more
connections by lowering their overhead (by reusing PostgreSQL's
connections). I'm confused.  I'm looking for advice similar to
the ones found in PostgreSQL's wiki, like "this parameter should
be ~50% of your memory".  I remember there was a spreadsheet for
MySQL that would let you calculate these kind of parameters. It
would be awesome to have something like that for
PostgreSQL/pgbouncer.  share|improve this question  1 Answer 1
up vote 3 down vote accepted  First, please read our canonical
question on Capacity Planning. The specific advice you're asking
for is capacity planning advice, and you're go