Date: 07/08/00
- Next message: Björn Schotte: "Re: [phplib] db_oci8 next_record() and disconnect()"
- Previous message: fabrizio.ermini <email protected>: "Re: [phplib] Problem with permanent connections?"
- In reply to: toby cabot: "Re: [phplib] Problem with permanent connections?"
- Next in thread: Davor Cengija: "Re: [phplib] Problem with permanent connections?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> We'll see. It looks like php sets a limit on persistent database
> connections per process, so it would be pretty easy to use a lot of them if
> you've got a lot of apache processes running. The php config variable is
> pgsql.max_persistent (see also pgsql.max_links). I'd guess that
> pgsql.max_persistent times apache MaxClients needs to be less than the max
> number of pgsql back ends.
>
This surprises me a little. I thought there were a 1:1 relation
between apache child processes and database connections. Why
a http server process should need more than one database
connection?
However, this could explain the fact that when I reached the 32
postgres client limit, I had only 20 apache processes running. This
led me to think that there was something wrong.
> You can run more pg backend processes if you start up the postmaster with
> the -N switch. If you try to run too many you may have to tweak your OS
> configuration as well.
>
Thanks!
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Fabrizio Ermini Alternate E-mail:
C.so Umberto, 7 faermini <email protected>
loc. Meleto Valdarno Mail on GSM: (keep it short!)
52020 Cavriglia (AR) faermini <email protected>
---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>
- Next message: Björn Schotte: "Re: [phplib] db_oci8 next_record() and disconnect()"
- Previous message: fabrizio.ermini <email protected>: "Re: [phplib] Problem with permanent connections?"
- In reply to: toby cabot: "Re: [phplib] Problem with permanent connections?"
- Next in thread: Davor Cengija: "Re: [phplib] Problem with permanent connections?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

