Search Postgresql Archives

Re: supporting 2000 simultaneous connections.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>:

> Bill Moran wrote:
> > In response to Shiva Sarna <shiva.sarna@xxxxxxxxx>:
> > 
> >> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux