Re: Idle connections

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