Hi guys,

We just did a stress test on our web server. Approximately 30 minutes into the test, when number of concurrent users (60 users at this time) are increased, PHP would not connect to PostgreSQL.

Why does PosgreSQL shuts itself down for additional connections?

Any help would be much appreciated.
Joe

PostgreSQL's default settings are pretty conservative, so it can even be installed on a low-end machine. There is a hard limit to the number of concurrent users, that can be changed in postgresql.conf.

Here are a few other good links for tuning PostgreSQL:

http://www.phpbuilder.com/columns/smith20010821.php3

http://www.ca.postgresql.org/docs/momjian/hw_performance/

http://techdocs.postgresql.org/techdocs/pgsqldbtuning.php