Re: Persistent Connects (pg_pconnect)

> Not sure if this is related, but under the non-threading Apache
> server, you get 1 persistent connection per Apache process.  I don't
> think you can be sure which process gets the page with the connection
> request, so if you have a limit of, say, 50 processes, and your server
> is hit fairly often, eventually you'll see 50 connections even though
> only a few simultaneous accesses to PHP/PostgreSQL are made.
>
> Or, I could be totally off.
>
> -itai

Actually, with php 4.0x, the apache processes can gather a pool of persistent connexions.

I had the same sort of problem once, and saw that each apache process was grabbing ~4
postgreSQL connexions and thus maxing out the number available from the server.