pgsql: Add VACUUM (DISABLE_PAGE_SKIPPING) for emergencies.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add VACUUM (DISABLE_PAGE_SKIPPING) for emergencies.
Date: 2016-06-17 19:53:11
Message-ID: E1bDzpH-0000AO-V5@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add VACUUM (DISABLE_PAGE_SKIPPING) for emergencies.

If you really want to vacuum every single page in the relation,
regardless of apparent visibility status or anything else, you can use
this option. In previous releases, this behavior could be achieved
using VACUUM (FREEZE), but because we can now recognize all-frozen
pages as not needing to be frozen again, that no longer works. There
should be no need for routine use of this option, but maybe bugs or
disaster recovery will necessitate its use.

Patch by me, reviewed by Andres Freund.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/ede62e56fbe809baa1a7bc3873d82f12ffe7540b

Modified Files
--------------
doc/src/sgml/ref/vacuum.sgml | 21 +++++++-
src/backend/commands/vacuum.c | 9 ++++
src/backend/commands/vacuumlazy.c | 97 ++++++++++++++++++++----------------
src/backend/parser/gram.y | 10 ++++
src/include/nodes/parsenodes.h | 3 +-
src/test/regress/expected/vacuum.out | 1 +
src/test/regress/sql/vacuum.sql | 2 +
7 files changed, 97 insertions(+), 46 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2016-06-17 20:30:19 pgsql: Try again to fix the way the scanjoin_target is used with partia
Previous Message Robert Haas 2016-06-17 19:39:21 pgsql: Update dblink extension for parallel query.