Re: Setting up a database for 10000 concurrent users - Mailing 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
>
>

No doubt that would be a problem.  Its bad idea.  set max_connections to core count * 2, then put pg_pool in front, and
setpg_pools max count to 10000. 

-Andy