postgres.git / summary / log / commit / refs
commit 3379263b6ded774acb96288d1e67caa37dcba0de
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: Mon Nov 18 07:51:09 2013 +0000
First released in: 9.4.0, 9.2.6, 9.3.2
Count locked pages that don't need vacuuming as scanned.
Previously, if VACUUM skipped vacuuming a page because it's pinned, it
didn't count that page as scanned. However, that meant that relfrozenxid
was not bumped up either, which prevented anti-wraparound vacuum from
doing its job.
Report by Миша Тюрин, analysis and patch by Sergey Burladyn and Jeff Janes.
Backpatch to 9.2, where the skip-locked-pages behavior was introduced.
src/backend/commands/vacuumlazy.c | 1 +
1 file changed, 1 insertion(+)
diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c
index 28f169e59c5..782f59e64d2 100644
--- a/src/backend/commands/vacuumlazy.c
+++ b/src/backend/commands/vacuumlazy.c
@@ -589,6 +589,7 @@ lazy_scan_heap(Relation onerel, LVRelStats *vacrelstats,
if (!lazy_check_needs_freeze(buf))
{
UnlockReleaseBuffer(buf);
+ vacrelstats->scanned_pages++;
continue;
}
LockBuffer(buf, BUFFER_LOCK_UNLOCK);
[parent: b18882aed6bf]