Thread: pgsql: Fix lazy_scan_heap so that it won't mark pages all-frozen too so

pgsql: Fix lazy_scan_heap so that it won't mark pages all-frozen too so

From
Robert Haas
Date:
Fix lazy_scan_heap so that it won't mark pages all-frozen too soon.

Commit a892234f830e832110f63fc0a2afce2fb21d1584 added a new bit per
page to the visibility map fork indicating whether the page is
all-frozen, but incorrectly assumed that if lazy_scan_heap chose to
freeze a tuple then that tuple would not need to later be frozen
again. This turns out to be false, because xmin and xmax (and
conceivably xvac, if dealing with tuples from very old releases) could
be frozen at separate times.

Thanks to Andres Freund for help in uncovering and tracking down this
issue.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/38e9f90a227d1e60e7b4691d1a71fefaba6059e5

Modified Files
--------------
src/backend/access/heap/heapam.c  | 45 ++++++++++++++++++++++++++++-----------
src/backend/commands/vacuumlazy.c |  8 +++++--
src/include/access/heapam_xlog.h  |  3 ++-
3 files changed, 40 insertions(+), 16 deletions(-)