I am working on a web application where the front end is struts framework and back end is PgSQL 7.4.
The client want us to support 2000 simultaneous users. My question is will there be any performance degradation if I increase the max_connections of pgsql to 2000.
Is there a limit to maximum number of simultaneous user supoorted by pgsql.
thanks for your time and help.
regards
Shiva Here’s a new way to find what you're looking for - Yahoo! Answers
You can test it. Use JMeter (http://jakarta.apache.org/jmeter/) and stress it to know where the limit is (according to your hardware, of course).