On Thu, 2007-03-01 at 18:09, Mariano Mara wrote: > Shiva Sarna escribió: > > Hi, > > > > 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. > 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). I have to toss my hat in on jmeter as well. It's not perfect, but it gets the job done, and has a lot of programmability in it.