Home > mailing lists

IDLE queries taking up space - Mailing list pgsql-general

From	JD Wong
Subject	IDLE queries taking up space
Date	August 30, 2011 14:09:12
Msg-id	CAGuHHn8J8-taczYqiz6_=UAJ=O4Ni8YO=P9p1a_pS7OcKAJuRA@mail.gmail.com Whole thread Raw
Responses	Re: IDLE queries taking up space Re: IDLE queries taking up space Re: IDLE queries taking up space
List	pgsql-general

Tree view

Hi,

When I run select datname, procpid, current_query from pg_stat_activity; I get 26 rows of <IDLE> queries. How can I set postgres to qutomatically close connections that have finished their queries and now sit idle?

Thanks!

-JD

pgsql-general by date:

From: Scott Ribe
Date: 30 August 2011, 14:00:45
Subject: Re: duplicate key violates unique on a nextval() field

From: Peter Warasin
Date: 30 August 2011, 14:09:35
Subject: duplicate key violates unique on a nextval() field

IDLE queries taking up space - Mailing list pgsql-general

Previous

Next