From: Tom Lane <tgl@sss.pgh.pa.us>
To: Craig James <cjames@emolecules.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Odd DEALLOCATE statements never finish in 9.2?
Date: Thu, 18 Oct 2012 17:54:46 -0400
Message-ID: <20442.1350597286@sss.pgh.pa.us> (raw)
In-Reply-To: <CAFwQ8rfvsRe0XJt6F=TS6TB0=02xshTK_TNE=BkDa2SO4wQJPQ@mail.gmail.com>
References: <CAFwQ8rfvsRe0XJt6F=TS6TB0=02xshTK_TNE=BkDa2SO4wQJPQ@mail.gmail.com>
Craig James <cjames@emolecules.com> writes:
> I installed 9.2 on our new server and am seeing something odd that doesn't
> happen in 8.4:
> postgres=# select datname, pid, usename, query from pg_stat_activity where
> query != '<IDLE>';
The query column now means "current or last query" --- there's a
separate column to check for the idle status. Those DEALLOCATEs
are evidently what your app does before going idle.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, cjames@emolecules.com
Subject: Re: Odd DEALLOCATE statements never finish in 9.2?
In-Reply-To: <20442.1350597286@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox