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@gmail.com> wrote:
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?