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 
FAQ