From: | Si Chen <sichen(at)opensourcestrategies(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: what does pg_activity mean when the database is stuck? |
Date: | 2014-06-12 02:44:09 |
Message-ID: | CAAYSSjNyWezd2FnVfu1da8MXu0_S3iM+k4RgYwoCZ1VQP4N0jg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is there a way to configure postgresql to automatically release connections
that have been idle for a set amount of time?
On Wed, Jun 11, 2014 at 3:41 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Wed, Jun 11, 2014 at 5:37 PM, Si Chen
> <sichen(at)opensourcestrategies(dot)com> wrote:
> > The state is "idle". I don't have the state_change, but I will try to
> > collect it if it happens again.
>
> If they are idle, then the problem is probably with your application
> -- you're grabbing new connections and not closing them or reusing
> them. It's a very common problem. The 'query' when idle represents
> the last query run -- the database finished it and is sitting around.
>
> merlin
>
--
Si Chen
Open Source Strategies, Inc.
sichen(at)opensourcestrategies(dot)com
http://www.OpenSourceStrategies.com
LinkedIn: http://www.linkedin.com/in/opentaps
Twitter: http://twitter.com/opentaps
From | Date | Subject | |
---|---|---|---|
Next Message | Saravanan Subramaniyan | 2014-06-12 06:43:21 | OpenSSL Vulnerabilities |
Previous Message | Tom Lane | 2014-06-11 23:24:36 | Re: [GENERAL] Question about partial functional indexes and the query planner |