Re: supporting 2000 simultaneous connections. - Mailing list pgsql-general

From Shiva Sarna
Subject Re: supporting 2000 simultaneous connections.
Date
Msg-id 310153.40372.qm@web55507.mail.re4.yahoo.com
Whole thread Raw
In response to Re: supporting 2000 simultaneous connections.  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
Hi,

Thanks for your reply and help.

The web application I am talking about is a Learning
Management System.

By simultaneous users I mean that all 2000 users
should be able to access the application and for
example say take a test.

We are using JNDI connection pooling.

I think we have to now think about upgrading the
hardware as well.

thanks for your time.

regards

Shiva






--- Bill Moran <wmoran@collaborativefusion.com> wrote:

> In response to "Joshua D. Drake"
> <jd@commandprompt.com>:
>
> > 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.
>
> Oops ... didn't notice that.
>
> --
> Bill Moran
> Collaborative Fusion Inc.
>




__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PG Dump 8.2
Next
From: mobiledreamers@gmail.com
Date:
Subject: Re: US Highschool database in postgres