pg.ddx.io pgsql-php@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Too many processes 4+ messages / 2 participants [nested] [flat]
* Too many processes @ 2005-07-19 14:12 Fabio Hecht - Nitrodev <fabio@nitrodev.com> 0 siblings, 0 replies; 4+ messages in thread From: Fabio Hecht - Nitrodev @ 2005-07-19 14:12 UTC (permalink / raw) To: pgsql-php 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 about 4 hours) reaches 150 httpd and postmaster processes, making it stop responding. I tried both pg_connect() and pg_pconnect(), and I got similar results. 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Too many processes @ 2005-07-19 15:06 Fabio Hecht <fhecht@yahoo.com> 0 siblings, 0 replies; 4+ messages in thread From: Fabio Hecht @ 2005-07-19 15:06 UTC (permalink / raw) To: pgsql-php 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Too many processes @ 2005-07-19 15:11 Fabio Hecht <fhecht@yahoo.com> 0 siblings, 0 replies; 4+ messages in thread From: Fabio Hecht @ 2005-07-19 15:11 UTC (permalink / raw) To: pgsql-php 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Too many processes @ 2005-07-20 22:36 Fabio Hecht <fhecht@yahoo.com> 0 siblings, 0 replies; 4+ messages in thread From: Fabio Hecht @ 2005-07-20 22:36 UTC (permalink / raw) To: Matthew Terenzio <matt@jobsforge.com>; pgsql-php 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-07-20 22:36 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-19 14:12 Too many processes Fabio Hecht - Nitrodev <fabio@nitrodev.com> 2005-07-19 15:06 Too many processes Fabio Hecht <fhecht@yahoo.com> 2005-07-19 15:11 Too many processes Fabio Hecht <fhecht@yahoo.com> 2005-07-20 22:36 Re: Too many processes Fabio Hecht <fhecht@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox