From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Shiva Sarna <shiva(dot)sarna(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: supporting 2000 simultaneous connections. |
Date: | 2007-03-01 17:33:52 |
Message-ID: | 20070301123352.fcbf8ec2.wmoran@collaborativefusion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to "Joshua D. Drake" <jd(at)commandprompt(dot)com>:
> Bill Moran wrote:
> > In response to Shiva Sarna <shiva(dot)sarna(at)yahoo(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | George Nychis | 2007-03-01 17:35:29 | Re: get username of user calling function? |
Previous Message | David Legault | 2007-03-01 17:30:18 | Re: get username of user calling function? |