Re: supporting 2000 simultaneous connections. - Mailing list pgsql-general

From Scott Marlowe
Subject Re: supporting 2000 simultaneous connections.
Date
Msg-id 1172851223.20651.192.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: supporting 2000 simultaneous connections.  (Mariano Mara <mmara@fibertel.com.ar>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: psql client quits after 1st command
Next
From: Tom Lane
Date:
Subject: Re: pg_dump, serial