Re: [DOCS] Autovacuum and XID wraparound - Mailing list pgsql-patches

From Tom Lane
Subject Re: [DOCS] Autovacuum and XID wraparound
Date
Msg-id 7145.1179347418@sss.pgh.pa.us
Whole thread Raw
In response to Re: [DOCS] Autovacuum and XID wraparound  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: [DOCS] Autovacuum and XID wraparound  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Tom Lane wrote:
>> Heikki Linnakangas <heikki@enterprisedb.com> writes:
>>> Now that I think this a bit more, I think CLUSTER should freeze the
>>> tuples.
>>
>> I disagree with that...

> Ok. Why?

It's removing potentially-important data without any notice or recourse
to the user.  There seems to be a contingent around here that thinks
that as soon as xmin is older than GlobalXmin it is no longer of
interest to anyone, but I have lost count of how often I have found it
invaluable for forensic purposes.  I have resisted having VACUUM freeze
tuples before they've reached a quite-respectable age, and I object to
having CLUSTER do it either.

I could maybe accept a CLUSTER FREEZE option to do this, but that's not
what's in the patch.

            regards, tom lane

pgsql-patches by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Allow elog_node_display() to show INSERTs
Next
From: Heikki Linnakangas
Date:
Subject: Re: [DOCS] Autovacuum and XID wraparound