pgsql: Count locked pages that don't need vacuuming as scanned.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Count locked pages that don't need vacuuming as scanned.
Date: 2013-11-18 08:22:19
Message-ID: E1ViK67-0008PY-H0@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4c697d8f4845823a8af67788b219ffa4516ad14c

Modified Files
--------------
src/backend/commands/vacuumlazy.c | 1 +
1 file changed, 1 insertion(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2013-11-18 15:26:45 pgsql: Use cstring_to_text_with_len when length is known.
Previous Message Tom Lane 2013-11-17 20:06:57 pgsql: Add make_date() and make_time() functions.