Re: Maximum number of client connection supported by Postgres 8.4.6

Hello

2011/7/21 Jenish Vyas <jenishvyas@gmail.com>:
> Hi All,
>
> please let me know what is the maximum number of concurrent client
> connection supported by Postgres 8.4.6
>
> max_connections = ????
>
> For my database,
>
> If I am running the test for more then 1000 concurrent active user it is
> showing me error “running out of connection”
>
> I have set max_connections = 1200.
>
> Thanks & regards,
> JENISH VYAS
>

this is just note - maximum connections should be related to  number
of processors on the server - optimum is about 20-30. Very high number
of current concurrent connections is very ineffective - there is very
high content switch overhead. If you need it, the use some connection
pool sw like pgPool or pgBouncer

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Connection_Pooling_and_Acceleration

Regards

Pavel Stehule
>
>