Re: Setting up a database for 10000 concurrent users

Поиск
Список
Период
Сортировка
От Andy Colson
Тема Re: Setting up a database for 10000 concurrent users
Дата
Msg-id 55477D5A.4030500@squeakycode.net
обсуждение исходный текст
Ответ на Re: Setting up a database for 10000 concurrent users  (sanjeetkamble <sanjeetkamble@rediffmail.com>)
Ответы Re: Setting up a database for 10000 concurrent users
Список pgsql-general
On 05/04/2015 02:02 AM, sanjeetkamble wrote:
> Hello,
>
> Please let me know how The database server is started with max_connections =
> 10000 ???
>
> I have same issue, but i have a SAN storage where Postgresql  is installed.
>
>
> Sanjeet
>
>

No doubt that would be a problem.  Its bad idea.  set max_connections to core count * 2, then put pg_pool in front, and
setpg_pools max count to 10000. 

-Andy



В списке pgsql-general по дате отправления:

Предыдущее
От: sanjeetkamble
Дата:
Сообщение: Re: Setting up a database for 10000 concurrent users
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Setting up a database for 10000 concurrent users