Skip site navigation (1) Skip section navigation (2)

Re: [DOCS] Autovacuum and XID wraparound

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-patches(at)postgresql(dot)org, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: [DOCS] Autovacuum and XID wraparound
Date: 2007-05-16 08:22:02
Message-ID: 464ABF2A.3000005@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
Alvaro Herrera wrote:
> In any case the change is a very small patch, which I attach but I
> haven't tested.  This only works if the new rewriteheap stuff actually
> changes Xids to follow OldestXmin, i.e. all tuples that have older
> Xmin/Xmax are frozen (or marked with the current Xid).  Heikki, can you
> confirm that this is the case?

No, CLUSTER doesn't freeze tuples. It could do that easily, it didn't 
occur to me when I wrote it. It would make it harder to debug, though, 
should we have any problems with it in the future.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-docs by date

Next:From: Alvaro HerreraDate: 2007-05-16 12:44:20
Subject: Re: [DOCS] Autovacuum and XID wraparound
Previous:From: Heikki LinnakangasDate: 2007-05-16 08:12:23
Subject: Re: [PATCHES] OS/X startup scripts

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2007-05-16 12:44:20
Subject: Re: [DOCS] Autovacuum and XID wraparound
Previous:From: Heikki LinnakangasDate: 2007-05-16 08:12:23
Subject: Re: [PATCHES] OS/X startup scripts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group