Re: Setting up a database for 10000 concurrent users

From: Andy Colson <andy(at)squeakycode(dot)net>
To: sanjeetkamble <sanjeetkamble(at)rediffmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Setting up a database for 10000 concurrent users
Date: 2015-05-04 14:08:26
Message-ID: 55477D5A.4030500@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2015-05-04 14:22:37 Re: Setting up a database for 10000 concurrent users
Previous Message Dave Cramer 2015-05-04 11:11:47 Re: Errors using JDBC batchUpdate with plpgsql function