Search Postgresql Archives
IDLE queries taking up space
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: pgsql-general <
pgsql-general@xxxxxxxxxxxxxx
>
Subject
: IDLE queries taking up space
From
: JD Wong <
jdmswong@xxxxxxxxx
>
Date
: Tue, 30 Aug 2011 12:03:48 -0400
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: IDLE queries taking up space
From:
Craig Ringer
Re: IDLE queries taking up space
From:
Merlin Moncure
Re: IDLE queries taking up space
From:
Scott Ribe
Prev by Date:
Re: duplicate key violates unique on a nextval() field
Next by Date:
duplicate key violates unique on a nextval() field
Previous by thread:
duplicate key violates unique on a nextval() field
Next by thread:
Re: IDLE queries taking up space
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
