Re: Postgre and Web Request - Mailing list pgsql-general

    Oww ... sorry man ...
    I make a mistake ... there are 10.000 users and 1.000 from 10.000 try to
access at the same time the database.
    Can you help me again with this condition?

    Grettings
        Kilmer Cruz

----- Original Message -----
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Kilmer C. de Souza" <listas@miti.com.br>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, April 28, 2004 3:56 PM
Subject: Re: [GENERAL] Postgre and Web Request


>
> >                 (the manual stated the following: there is a main
process
> > called postmaster. It starts new processes to each different request and
> > each different user ... I dont understand very well ...  please correct
me
> > if I`m wrong)
> >         If all users try to access, through WEB, at same time the
database,
> > what happens:
>
> Well the likelyhood of 10,000 users accessing the website at the EXACT
> same time is highly unlikely (exponentially so). Remember the web is
> stateless so each full request is processed and then the connection is
> terminated. This means that connection to postgresql will also be
> dropped (unless you use something like connection pooling or persistent
> connections).
>
> >             1. With the OS? Will it crash?
>
> See above. And actually if you really did have a situation where 10,000
> users accessed the site at the exact same time you would need a pretty
> large cluster to handle it... regardless of PostgreSQL.
>
> >             2. Will the Postmaster process startup 10.000 diferent
processes
> > at the same time?
>
> See above.
>
> >             3. What about performance? Is there any peformance
downgrade?
>
> Depends on the machine but that would be the case with any database.
>
>
> >             4. What is the best solution for this problem?
>
> You are asking for a solution to a problem that doesn't really exist at
> the database level. You need to spec your hardware requirements overall
> and get an firmer understaning of your application requirements. Like I
> said, it is highly unlikely that your demands are as high as you mention.
>
>
> >             5. How many simultaneos requests may the Postmaster open
> > withouth decreasing perfomance?
> >
>
> Depends on the machine... ram, amount of hard disks (not space, quantity
> of disks) etc...
>
> Sincerely,
>
> Joshua D. Drake
>
>
> >
> >         Grettings,
> >             Kilmer Cruz
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
>
>