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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-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

Browse pgsql-docs by date

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

Browse pgsql-patches by date

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