diff options
| author | Amit Kapila <akapila@postgresql.org> | 2020-01-29 11:08:50 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2020-01-29 11:08:50 +0530 |
| commit | 47bc9ced0d0e96523e2c639c7066c9aede189ed7 (patch) | |
| tree | a7753690cf761e3866c6378a66e0127c740bbe63 /doc/src | |
| parent | 01d9676a53af075feb42d2f83ddb8c61186812fc (diff) | |
| download | postgresql-47bc9ced0d0e96523e2c639c7066c9aede189ed7.tar.gz postgresql-47bc9ced0d0e96523e2c639c7066c9aede189ed7.zip | |
Add --parallel option to vacuumdb command.
Commit 40d964ec99 allowed vacuum command to leverage multiple CPUs by
invoking parallel workers to process indexes. This commit provides a
'--parallel' option to specify the parallel degree used by vacuum command.
Author: Masahiko Sawada, with few modifications by me
Reviewed-by: Mahendra Singh and Amit Kapila
Discussion: https://postgr.es/m/CAD21AoDTPMgzSkV4E3SFo1CH_x50bf5PqZFQf4jmqjk-C03BWg@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 47d93456f86..775c9ec651b 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -227,6 +227,24 @@ PostgreSQL documentation </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> + <para> + Specify the parallel degree of <firstterm>parallel vacuum</firstterm>. + This allows the vacuum to leverage multiple CPUs to process indexes. + See <xref linkend="sql-vacuum"/>. + </para> + <note> + <para> + This option is only available for servers running + <productname>PostgreSQL</productname> 13 and later. + </para> + </note> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-q</option></term> <term><option>--quiet</option></term> <listitem> |