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.