diff options
| author | Robert Haas | 2016-06-17 19:48:57 +0000 |
|---|---|---|
| committer | Robert Haas | 2016-06-17 19:48:57 +0000 |
| commit | ede62e56fbe809baa1a7bc3873d82f12ffe7540b (patch) | |
| tree | bed6a8e258dc9148b2141b0a8e112a0b864bc283 /src/test | |
| parent | 20eb2731b7775f3381939d2667b6aa8ba62ab2c5 (diff) | |
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.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/vacuum.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/vacuum.sql | 2 |
2 files changed, 3 insertions, 0 deletions
diff --git a/src/test/regress/expected/vacuum.out b/src/test/regress/expected/vacuum.out index d2d75038286..9b604be4b62 100644 --- a/src/test/regress/expected/vacuum.out +++ b/src/test/regress/expected/vacuum.out @@ -79,5 +79,6 @@ ERROR: ANALYZE cannot be executed from VACUUM or ANALYZE CONTEXT: SQL function "do_analyze" statement 1 SQL function "wrap_do_analyze" statement 1 VACUUM FULL vactst; +VACUUM (DISABLE_PAGE_SKIPPING) vaccluster; DROP TABLE vaccluster; DROP TABLE vactst; diff --git a/src/test/regress/sql/vacuum.sql b/src/test/regress/sql/vacuum.sql index f8412016cf3..7b819f654dd 100644 --- a/src/test/regress/sql/vacuum.sql +++ b/src/test/regress/sql/vacuum.sql @@ -60,5 +60,7 @@ VACUUM FULL pg_database; VACUUM FULL vaccluster; VACUUM FULL vactst; +VACUUM (DISABLE_PAGE_SKIPPING) vaccluster; + DROP TABLE vaccluster; DROP TABLE vactst; |