Quick Links

IDLE queries taking up space

From:	JD Wong <jdmswong(at)gmail(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	IDLE queries taking up space
Date:	2011-08-30 16:03:48
Message-ID:	CAGuHHn8J8-taczYqiz6_=UAJ=O4Ni8YO=P9p1a_pS7OcKAJuRA@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: IDLE queries taking up space at 2011-08-30 17:13:51 from Scott Ribe
Re: IDLE queries taking up space at 2011-08-30 19:04:02 from Merlin Moncure
Re: IDLE queries taking up space at 2011-08-31 01:16:22 from Craig Ringer

Browse pgsql-general by date

	From	Date	Subject
Next Message	Lonni J Friedman	2011-08-30 16:17:54	Re: heavy swapping, not sure why
Previous Message	Peter Warasin	2011-08-30 15:28:05	duplicate key violates unique on a nextval() field