Re: IDLE queries taking up space

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: JD Wong <jdmswong(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: IDLE queries taking up space
Date: 2011-08-30 17:13:51
Message-ID: 2B02175D-5C97-4671-A263-8C628A69CE39@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Aug 30, 2011, at 10:03 AM, JD Wong wrote:

> How can I set postgres to qutomatically close connections that have finished their queries and now sit idle?

They haven't finished their queries. They've opened transactions, and then are sitting there doing nothing. In other words, this is a bug in your clients, and no, you really would not want PG automatically terminating connections mid-transaction just because it thought the client was taking too long to get to the next step.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-08-30 17:14:06 COPY failure on directory I own
Previous Message Scott Ribe 2011-08-30 16:56:11 Re: duplicate key violates unique on a nextval() field