Re: vacuum vs open transactions - Mailing list pgsql-general

From Michael Fuhr
Subject Re: vacuum vs open transactions
Date
Msg-id 20050113192123.GA40725@winnie.fuhr.org
Whole thread Raw
In response to Re: vacuum vs open transactions  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
On Thu, Jan 13, 2005 at 10:33:50AM -0700, Ed L. wrote:
> On Thursday January 13 2005 10:09, Michael Fuhr wrote:
> >
> > For idle transactions pg_stat_activity shows "<IDLE> in transaction"
> > and the query_start column shows when the transaction became idle
>
> That will help, thanks.  Unfortunately, that doesn't appear to work for many
> of our pre-7.4 clusters, of which we have 60, but that will definitely help
> as we migrate forward.

Ah yes, I see in the Relase Notes that the query start time was
added in 7.4.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: vacuum vs open transactions
Next
From: "Frank D. Engel, Jr."
Date:
Subject: Re: allowing connections from additional hosts without a restart?