[imp] postgresql maxing out

[Eric Rostetter]

To those having problems with postgresql maxing out available connections,
a question:

Do you have your apache web server creating more children than you allow
postgresql connections?

It seems if you're using php with connection pooling (i.e. pg_pconnect) then
each apache child spawned will keep open any connection it opens for reuse.
So if your child limit in apache is higher than your allowed connections to
postgresql, you can run out of postgresql connections...

I'm betting this is the problem.  I never see this as my max httpd clients
is less than my max postgresql connections...  I've checked, and my number
of postgresql jobs is almost always the same as the number of apache jobs
minus one.

-- 
Eric Rostetter
The Department of Physics
The University of Texas at Austin

Why get even? Get odd!