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.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/