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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
