Have CLUSTER advance the table's relfrozenxid. The new frozen point is the

Alvaro Herrera <alvherre@alvh.no-ip.org>

Commit: b40776d22185423f57e32b9c9fcac2326fdb4fde
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2007-05-18T23:19:42Z
Releases: 8.3.0
Have CLUSTER advance the table's relfrozenxid.  The new frozen point is the
FreezeXid introduced in a recent commit, so there isn't any data loss in this
approach.

Doing it causes ALTER TABLE (or rather, the forms of it that cause a full table
rewrite) to be affected as well.  In this case, the frozen point is RecentXmin,
because after the rewrite all the tuples are relabeled with the rewriting
transaction's Xid.

TOAST tables are fixed automatically as well, as fallout of the way they were
already being handled in the respective code paths.

With this patch, there is no longer need to VACUUM tables for Xid wraparound
purposes that have been cleaned up via TRUNCATE or CLUSTER.

Files

PathChange+/−
src/backend/commands/cluster.c modified +22 −7
src/backend/commands/tablecmds.c modified +8 −3
src/include/commands/cluster.h modified +2 −2