From: om prash jaiswal <op12om@yahoo.co.in>
To: Amardeep Kaur <amardeepkaur88@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Increasing maximum connection for postgresql 9.2
Date: Fri, 21 Feb 2014 15:41:24 +0800 (SGT)
Message-ID: <1392968484.24487.YahooMailNeo@web190805.mail.sg3.yahoo.com> (raw)
In-Reply-To: <CAJ1JmhVa5d-3YUZLWYgv9s_AoBVsVxzGcLB8ut_i3Xkz7g-=nA@mail.gmail.com>
References: <CAJ1JmhVa5d-3YUZLWYgv9s_AoBVsVxzGcLB8ut_i3Xkz7g-=nA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: op12om@yahoo.co.in, amardeepkaur88@gmail.com
Subject: Re: Increasing maximum connection for postgresql 9.2
In-Reply-To: <1392968484.24487.YahooMailNeo@web190805.mail.sg3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox