diff options
| author | Michael Paquier <michael@paquier.xyz> | 2020-06-22 13:23:38 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2020-06-22 13:23:38 +0900 |
| commit | 9550ea3027aa4f290c998afd8836a927df40b09d (patch) | |
| tree | 03e1a237a566ba773cc58201f134ec85c4918bc1 /doc/src | |
| parent | 14903f238ec999802df5c539010c6be32d72f8cd (diff) | |
| download | postgresql-9550ea3027aa4f290c998afd8836a927df40b09d.tar.gz postgresql-9550ea3027aa4f290c998afd8836a927df40b09d.zip | |
Add --no-index-cleanup and --no-truncate to vacuumdb.
Both INDEX_CLEANUP and TRUNCATE have been available since v12, and are
enabled by default except if respectively vacuum_index_cleanup and
vacuum_truncate are disabled for a given relation. This change adds
support for disabling these options from vacuumdb.
Author: Nathan Bossart
Reviewed-by: Michael Paquier, Masahiko Sawada
Discussion: https://postgr.es/m/6F7F17EF-B1F2-4681-8D03-BA96365717C0@amazon.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index fd1dc140aba..95d6894cb03 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -227,6 +227,36 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--no-index-cleanup</option></term> + <listitem> + <para> + Do not remove index entries pointing to dead tuples. + </para> + <note> + <para> + This option is only available for servers running + <productname>PostgreSQL</productname> 12 and later. + </para> + </note> + </listitem> + </varlistentry> + + <varlistentry> + <term><option>--no-truncate</option></term> + <listitem> + <para> + Do not truncate empty pages at the end of the table. + </para> + <note> + <para> + This option is only available for servers running + <productname>PostgreSQL</productname> 12 and later. + </para> + </note> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-P <replaceable class="parameter">parallel_degree</replaceable></option></term> <term><option>--parallel=<replaceable class="parameter">parallel_degree</replaceable></option></term> <listitem> |