pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / 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