Re: Increasing maximum connection for postgresql 9.2 - Mailing list pgsql-admin

From Amardeep Kaur
Subject Re: Increasing maximum connection for postgresql 9.2
Date
Msg-id CAJ1JmhXm_RV+BLYcTMC3j6it9xNWAAcdtTR+fVE+zKw-J1wtrg@mail.gmail.com
Whole thread Raw
In response to Re: Increasing maximum connection for postgresql 9.2  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
Hey Jorge

My work_mem is 1 MB. I only modified max_connection and shared_buffer. Can you tell me how should I modify this? Is there any rule based on your RAM to decide these parameters?

-Amardeep


On Fri, Feb 21, 2014 at 12:34 AM, Jorge Torralba <jorge.torralba@gmail.com> wrote:
How much memory does your server have.What is your work_mem set to ?


On Thu, Feb 20, 2014 at 6:35 PM, Amardeep Kaur <amardeepkaur88@gmail.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




--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.



--
Amardeep Kaur
8130553685

pgsql-admin by date:

Previous
From: om prash jaiswal
Date:
Subject: Re: Increasing maximum connection for postgresql 9.2
Next
From: Albe Laurenz
Date:
Subject: Re: Increasing maximum connection for postgresql 9.2