Re: PGSQL 7.4.8 : idle in transaction problem - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: PGSQL 7.4.8 : idle in transaction problem
Date
Msg-id 20050720051115.GA19849@alvh.no-ip.org
Whole thread Raw
In response to Re: PGSQL 7.4.8 : idle in transaction problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PGSQL 7.4.8 : idle in transaction problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Tue, Jul 19, 2005 at 10:44:35PM -0400, Tom Lane wrote:

> If it's a matter of whether VACUUM removes rows or not, that's expected:
> open-transaction bookkeeping is done across the whole cluster.  (This is
> not something simple to change, since we may have to consider
> transaction IDs in shared catalogs.)

I wonder if this restriction could be lifted if we tracked last-vacuum-
Xid per relation?

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Cuando mañana llegue pelearemos segun lo que mañana exija" (Mowgli)

pgsql-admin by date:

Previous
From: guo weidong
Date:
Subject: can not start the postgresql, i use gentoo
Next
From: Peter Eisentraut
Date:
Subject: Re: can not start the postgresql, i use gentoo