Hello 2011/7/21 Jenish Vyas <jenishvyas@xxxxxxxxx>: > 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 > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
