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

From Bill Moran
Subject Re: supporting 2000 simultaneous connections.
Date
Msg-id 20070301123352.fcbf8ec2.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: supporting 2000 simultaneous connections.  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: supporting 2000 simultaneous connections.  (Shiva Sarna <shiva.sarna@yahoo.com>)
List pgsql-general
In response to "Joshua D. Drake" <jd@commandprompt.com>:

> Bill Moran wrote:
> > In response to Shiva Sarna <shiva.sarna@yahoo.com>:
> >
> >> Hi,
> >>
> >> I am working on a web application where the front end is struts framework
> >> and back end is PgSQL 7.4.
>
> *cough*, you are going to greatly decrease your ability to scale if you
> are running anything less than 8.1.
> >
> > Performance _will_ degrade if all of those connections are busy at once, but
> > that's going to happen with any shared system.  The disk can only read from
> > one area at a time, and other system resources will be contended for as well.
>
> 7.4 doesn't scale to what he wants, even on big hardware.

Oops ... didn't notice that.

--
Bill Moran
Collaborative Fusion Inc.

pgsql-general by date:

Previous
From: "David Legault"
Date:
Subject: Re: get username of user calling function?
Next
From: George Nychis
Date:
Subject: Re: get username of user calling function?