diff options
| author | Michael Paquier <michael@paquier.xyz> | 2019-01-08 10:52:29 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2019-01-08 10:52:29 +0900 |
| commit | 354e95d1f2122d20c1c5895eb3973cfb0e8d0cc2 (patch) | |
| tree | 4057c50af3f6da8ebdb70cf7cf2fddea9e8eec09 /doc/src | |
| parent | a67212de198c9da70f04d2462474dc26965530c8 (diff) | |
| download | postgresql-354e95d1f2122d20c1c5895eb3973cfb0e8d0cc2.tar.gz postgresql-354e95d1f2122d20c1c5895eb3973cfb0e8d0cc2.zip | |
Add --disable-page-skipping and --skip-locked to vacuumdb
DISABLE_PAGE_SKIPPING is available since v9.6, and SKIP_LOCKED since
v12. They lacked equivalents for vacuumdb, so this closes the gap.
Author: Nathan Bossart
Reviewed-by: Michael Paquier, Masahiko Sawada
Discussion: https://postgr.es/m/FFE5373C-E26A-495B-B5C8-911EC4A41C5E@amazon.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 955a17a849b..da4d51e7635 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -103,6 +103,23 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--disable-page-skipping</option></term> + <listitem> + <para> + Disable all page-skipping behavior during processing based on + the visibility map, similarly to the option + <literal>DISABLE_PAGE_SKIPPING</literal> for <command>VACUUM</command>. + </para> + <note> + <para> + This option is only available for servers running + <productname>PostgreSQL</productname> 9.6 and later. + </para> + </note> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-e</option></term> <term><option>--echo</option></term> <listitem> @@ -168,6 +185,21 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--skip-locked</option></term> + <listitem> + <para> + Skip relations that cannot be immediately locked for processing. + </para> + <note> + <para> + This option is only available for servers running + <productname>PostgreSQL</productname> 12 and later. + </para> + </note> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-t <replaceable class="parameter">table</replaceable> [ (<replaceable class="parameter">column</replaceable> [,...]) ]</option></term> <term><option>--table=<replaceable class="parameter">table</replaceable> [ (<replaceable class="parameter">column</replaceable> [,...]) ]</option></term> <listitem> |