PHP with PostgreSQL - Too many processes

Author

Too many processes

Fabio Hecht

2005-07-19, 11:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Fabio Hecht

2005-07-20, 8:24 pm

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links