Too many processes
Too many processes
От:
Fabio Hecht <fhecht@yahoo.com>
Дата:
Hi! Can anyone help me? I have a Linux/Apache/PHP/PostgreSQL server. It has about 35 concurrent clients. The problem is it quickly (in a few hours) reaches 150 httpd and postmaster processes, making it stop responding. I tried both pg_connect() and pg_pconnect(), and I got similar results. The connection string is aways exactly the same. I don't think I should increase MaxClients beyond 150, because it doesn't have that many clients. Any help would be much appreciated. Cheers, Fabio __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Too many processes
От:
Fabio Hecht <fhecht@yahoo.com>
Дата:
Thanks for the answer Matthew. I just got it fixed. The problem was I had maxconnections too high in postgresql.conf. I had increased it to 1000 because the default value of 100 was too low. It seemed that it kept a lot of open connections even though I didn't use persistent connections in PHP. Well, the solution was decrease maxconnections to 200. Cheers, Fabio __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com