Re: supporting 2000 simultaneous connections.

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/