Increasing maximum connection for postgresql 9.2

Поиск
Список
Период
Сортировка
От Amardeep Kaur
Тема Increasing maximum connection for postgresql 9.2
Дата
Msg-id CAJ1JmhVa5d-3YUZLWYgv9s_AoBVsVxzGcLB8ut_i3Xkz7g-=nA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Increasing maximum connection for postgresql 9.2  (Jorge Torralba <jorge.torralba@gmail.com>)
Re: Increasing maximum connection for postgresql 9.2  (David Johnston <polobo@yahoo.com>)
Re: Increasing maximum connection for postgresql 9.2  (om prash jaiswal <op12om@yahoo.co.in>)
Re: Increasing maximum connection for postgresql 9.2  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-admin
Дерево обсуждения
Hey Guys

I am trying to increase the max_connection from 100 to 5000. I modified shared_buffer and changed kernel parameters according to
http://www.postgresql.org/docs/9.2/static/kernel-resources.html#SYSVIPC.
When i stress test it with 500 concurrent request, then after 150 - 160 concurrent connections my database enters into recovery mode and it fails the request. For my stress test i am trying to get data from one table.
Do you guys have any idea what is causing the problem or if i am missing some other configuration?

--
Amardeep Kaur

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

Предыдущее
От: Mel Llaguno
Дата:
Сообщение: Re: Availability of parallel jobs option in pg_dumpall
Следующее
От: Jorge Torralba
Дата:
Сообщение: Re: Increasing maximum connection for postgresql 9.2