Re: Setting up a database for 10000 concurrent users - Mailing list pgsql-general

From Andy Colson
Subject Re: Setting up a database for 10000 concurrent users
Date
Msg-id 55478322.50902@squeakycode.net
Whole thread Raw
In response to Re: Setting up a database for 10000 concurrent users  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Setting up a database for 10000 concurrent users
List pgsql-general
>
>     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@squeakycode.net <mailto:andy@squeakycode.net>> 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



pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Setting up a database for 10000 concurrent users
Next
From: Mathew Moon
Date:
Subject: Re: Removing and readding bdr nodes