The error is
could not receive data from client: Connection reset by peer
followed by could not receive data from client: Connection reset by peer
incomplete startup packet
On Fri, Feb 21, 2014 at 10:20 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
Amardeep Kaur wrote:As has been mentioned, that is too much.
> 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.
There is also an interesting article on the Wiki:
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
The database does not go into recovery mode just like that.
> 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?
Look into the database log and see if you can find the appropriate messages, then
we can figure out what caused the problem.
Yours,
Laurenz Albe
--
Amardeep Kaur
8130553685