pgbounce max_client_conn and default_pool_size

Поиск
Список
Период
Сортировка
От Yetkin Öztürk
Тема pgbounce max_client_conn and default_pool_size
Дата
Msg-id CALL033B48XeX5dkj4jabFMFbzi5qh+9giKau=AREVZf3W8iyXA@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Slow Delete : Seq scan instead of index scan
Следующее
От: Chris Ruprecht
Дата:
Сообщение: have: seq scan - want: index scan