Re: supporting 2000 simultaneous connections.

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.

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/