On 06/10/2010 14:26, Georgi Ivanov wrote:
> Hi,
> I have some issue where
> SELECT * from pg_stat_activity WHERE current_query='<IDLE>';
> returns too many rows .
What do you mean by "too many"?
> What is the meaning of IDLE ?
It means a client is keeping a connection open, but not executing any
queries.
> 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 ?
Are you using any kind of connection pooler?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
