]> granicus.if.org Git - postgresql/commit
Add VACUUM (DISABLE_PAGE_SKIPPING) for emergencies.
authorRobert Haas <rhaas@postgresql.org>
Fri, 17 Jun 2016 19:48:57 +0000 (15:48 -0400)
committerRobert Haas <rhaas@postgresql.org>
Fri, 17 Jun 2016 19:48:57 +0000 (15:48 -0400)
commitede62e56fbe809baa1a7bc3873d82f12ffe7540b
treebed6a8e258dc9148b2141b0a8e112a0b864bc283
parent20eb2731b7775f3381939d2667b6aa8ba62ab2c5
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.
doc/src/sgml/ref/vacuum.sgml
src/backend/commands/vacuum.c
src/backend/commands/vacuumlazy.c
src/backend/parser/gram.y
src/include/nodes/parsenodes.h
src/test/regress/expected/vacuum.out
src/test/regress/sql/vacuum.sql