On 05/04/2015 02:02 AM, sanjeetkamble wrote:
Hello,
Please let me know how The database server is started with max_connections =
10000 ???
I have same issue, but i have a SAN storage where Postgresql is installed.
Sanjeet
On Mon, May 4, 2015 at 10:08 AM, Andy Colson <andy@xxxxxxxxxxxxxxx <mailto:andy@xxxxxxxxxxxxxxx>> wrote:
No doubt that would be a problem. Its bad idea. set max_connections to core count * 2, then put pg_pool in front, and set pg_pools max count to 10000.
-Andy
On 05/04/2015 09:22 AM, Melvin Davidson wrote:
I suggest pg_bouncer as opposed to pg_pool. My testing showed it handled connections better. Ultimately the choice is yours, but with 10000 connections, you absolutely need a connection manger.
Oops. I meant pg_bouncer too. (I haven't had caffeine yet).
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
