| From: | om prash jaiswal <op12om(at)yahoo(dot)co(dot)in> |
|---|---|
| To: | Amardeep Kaur <amardeepkaur88(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Increasing maximum connection for postgresql 9.2 |
| Date: | 2014-02-21 07:41:24 |
| Message-ID: | 1392968484.24487.YahooMailNeo@web190805.mail.sg3.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Increase your kenal level parameter.
in the /etc/sysctl.conf file
kernal.shmmax=
kernal.shmin =
based on your RAM memory.
Give half of RAM size to these parameter.
calculate the value of kernal.shmmax, kernal.shmin from the given link.
http://www.postgresql.org/docs/9.2/static/kernel-resources.html#SYSVIPC.
On Friday, 21 February 2014 8:06 AM, Amardeep Kaur <amardeepkaur88(at)gmail(dot)com> wrote:
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amardeep Kaur | 2014-02-21 11:16:42 | Re: Increasing maximum connection for postgresql 9.2 |
| Previous Message | Tom Lane | 2014-02-21 06:11:15 | Re: error since upgrading to 9.3.3 plpgsql |