Idle connections

From: Georgi Ivanov <georgi(dot)r(dot)ivanov(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Idle connections
Date: 2010-10-06 13:26:32
Message-ID: AANLkTim9-sp0Tihgxrj44OFf+b0KOS4z86RVfTxkN2Gd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='<IDLE>';
returns too many rows .

What is the meaning of IDLE ?
I suspect that the server is overloaded with idle connections, but i don't
know why .
Sometimes i am forced to do
SELECT pg_terminate_backend(procpid) from pg_stat_activity where
current_query='<IDLE>';

Queries comes from 2 web nodes .

Any ideas why is this happening ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-10-06 13:33:26 Re: Idle connections
Previous Message Jutta Buschbom 2010-10-06 13:23:09 Re: Compilation of optional packages