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

From Joshua D. Drake
Subject Re: Postgre and Web Request
Date
Msg-id 408FFE40.8070000@commandprompt.com
Whole thread Raw
In response to Postgre and Web Request  ("Kilmer C. de Souza" <listas@miti.com.br>)
Responses Re: Postgre and Web Request
List pgsql-general
>                 (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

pgsql-general by date:

Previous
From: "Kilmer C. de Souza"
Date:
Subject: Postgre and Web Request
Next
From: Bill Moran
Date:
Subject: Re: Postgre and Web Request