From: David Johnston <polobo@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: Increasing maximum connection for postgresql 9.2
Date: Thu, 20 Feb 2014 19:39:01 -0800 (PST)
Message-ID: <1392953941857-5792989.post@n5.nabble.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>
Amardeep Kaur 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
Methinks you should probably "configure" a connection pooler.
Otherwise provide complete and detailed specifics on hardware, software, and
actual configuration values if you expect to get meaningful help on using
such an large max connections setting.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Increasing-maximum-connection-for-postgresql-9-2-tp5792978p5...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: polobo@yahoo.com
Subject: Re: Increasing maximum connection for postgresql 9.2
In-Reply-To: <1392953941857-5792989.post@n5.nabble.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