Re: supporting 2000 simultaneous connections.

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.

In response to

Responses

Browse pgsql-general by date

  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?