pgbounce max_client_conn and default_pool_size - Mailing list pgsql-performance

From Yetkin Öztürk
Subject pgbounce max_client_conn and default_pool_size
Date
Msg-id CALL033B48XeX5dkj4jabFMFbzi5qh+9giKau=AREVZf3W8iyXA@mail.gmail.com
Whole thread Raw
List pgsql-performance
What is the adequate pgbounce max_client_conn ,default_pool_size values for a postgres config which has max_connections = 400.

We want to move to pgbouncer to let postgres do the only db job but it confused us.  We have over 120 databases in a single postgres engine with as i said  max_connections = 400 .

120+ databases are driven from 3 separate web servers, we are planning to install pgbounce to three of them.

PS: in source code of pgbouncer it looks like opens separate fd's for max_client_conn * default_pool_size value.

Regards,

Yetkin Öztürk

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Slow Delete : Seq scan instead of index scan
Next
From: Chris Ruprecht
Date:
Subject: have: seq scan - want: index scan