Skip site navigation (1) Skip section navigation (2)

Re: Postgre and Web Request

From: "Kilmer C(dot) de Souza" <listas(at)miti(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgre and Web Request
Date: 2004-04-28 19:19:01
Message-ID: 003101c42d55$aa19bca0$2700000a@sistemas02 (view raw or flat)
Thread:
Lists: 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(at)commandprompt(dot)com>
To: "Kilmer C. de Souza" <listas(at)miti(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)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
>
>



In response to

Responses

pgsql-general by date

Next:From: Mike NolanDate: 2004-04-28 19:54:16
Subject: Re: Postgre and Web Request
Previous:From: Bill MoranDate: 2004-04-28 19:12:52
Subject: Re: Postgre and Web Request

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group