Re: Increasing maximum connection for postgresql 9.2

On Sat, Feb 22, 2014 at 12:37 AM, Amardeep Kaur <amardeepkaur88(at)gmail(dot)com>wrote:

> The error is
> *could not receive data from client: Connection reset by peer*
> followed by
> *incomplete startup packet*
>

True. As mentioned up the thread, this does not mean that the database is
in the recovery mode. If the database is in recovery mode, you would see a
straight forward message in the logs saying that the "database is in
recovery mode".

Please help us know how the connections or requests are sent to database
from Application. Is there anything you could see in Application/client
site logs ?

Things to be identified : If there are any unexpected connection
drops/hangs ? do you see any unexpected load spike on DB server ? Network
level issues etc.

Venkata Balaji N

Sr. Database Administrator
Fujitsu Australia

>
>
> -Amardeep
>
>
> On Fri, Feb 21, 2014 at 10:20 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:
>
>> Amardeep Kaur wrote:
>> > 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
>> .
>>
>> As has been mentioned, that is too much.
>> There is also an interesting article on the Wiki:
>> http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
>>
>> > 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?
>>
>> The database does not go into recovery mode just like that.
>> 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
>