Re: [ADMIN] idle connections

2009-10-06 Thread Steve Crawford
Aras Angelo wrote: Thank you for the informative post. We believe this was caused by a network issue yesterday after checking our network speeds. We were maxing our ethernet port at 100 mbps Ah, yes. In a previous life we once had a very successful internal load-test turn into a rapid and

Re: [ADMIN] idle connections

2009-10-06 Thread Aras Angelo
Thank you for the informative post. We believe this was caused by a network issue yesterday after checking our network speeds. We were maxing our ethernet port at 100 mbps, i believe some apache processes were hanging because of this issue, having no available bandwidth left. Considering an upgrad

Re: [ADMIN] idle connections

2009-10-06 Thread Steve Crawford
Aras Angelo wrote: ... When i kill the earliest idle process the others stop too. So i dont know whats wrong really. All our apps use the same footer, with pg_close() at the end ... I have done most of the things you guys suggested, so it seems to me that something between php-apache-post

Re: [ADMIN] idle connections

2009-10-05 Thread Scott Marlowe
On Mon, Oct 5, 2009 at 5:50 PM, Aras Angelo wrote: > Its a regular pg_connect() > > When i kill the earliest idle process the others stop too. So i dont know > whats wrong really. All our apps use the same footer, with pg_close() at the > end. > > I have done most of the things you guys suggested,

Re: [ADMIN] idle connections

2009-10-05 Thread Scott Marlowe
On Mon, Oct 5, 2009 at 5:50 PM, Aras Angelo wrote: > Its a regular pg_connect() > > When i kill the earliest idle process the others stop too. So i dont know > whats wrong really. All our apps use the same footer, with pg_close() at the > end. > > I have done most of the things you guys suggested,

Re: [ADMIN] idle connections

2009-10-05 Thread Aras Angelo
Its a regular pg_connect() When i kill the earliest idle process the others stop too. So i dont know whats wrong really. All our apps use the same footer, with pg_close() at the end. I have done most of the things you guys suggested, so it seems to me that something between php-apache-postgresql

Re: [ADMIN] idle connections

2009-10-05 Thread Scott Marlowe
On Mon, Oct 5, 2009 at 4:42 PM, Aras Angelo wrote: > Hi, > > Im seeing lots of idle connections (not idle in transaction) to my database > server. My front end is written with PHP and i couldnt find anything that > can cause this. If i do a kill proc-id every few minutes on my server via > cron, w

Re: [ADMIN] idle connections

2009-10-05 Thread Steve Crawford
Aras Angelo wrote: Hi, Im seeing lots of idle connections (not idle in transaction) to my database server. My front end is written with PHP and i couldnt find anything that can cause this. If i do a kill proc-id every few minutes on my server via cron, would this effect anything badly? Than

[ADMIN] idle connections

2009-10-05 Thread Aras Angelo
Hi, Im seeing lots of idle connections (not idle in transaction) to my database server. My front end is written with PHP and i couldnt find anything that can cause this. If i do a kill proc-id every few minutes on my server via cron, would this effect anything badly? Thanks