Re: IDLE queries taking up space - Mailing list pgsql-general

From Merlin Moncure
Subject Re: IDLE queries taking up space
Date
Msg-id CAHyXU0xoCd0Tkd6mz40NTAeHDhkyRovvGP5hDbh_R90qG-v6MA@mail.gmail.com
Whole thread Raw
In response to IDLE queries taking up space  (JD Wong <jdmswong@gmail.com>)
List pgsql-general
On Tue, Aug 30, 2011 at 11:03 AM, JD Wong <jdmswong@gmail.com> wrote:
> 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?

you don't. this should be managed from the client, or you can use a
connection pool.

merlin

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: heavy swapping, not sure why
Next
From: Tom Lane
Date:
Subject: Re: heavy swapping, not sure why