diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 3ecd9999812..e38c34aea37 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -204,6 +204,30 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>-j <replaceable class="parameter">njobs</replaceable></option></term> + <term><option>--jobs=<replaceable class="parameter">njobs</replaceable></option></term> + <listitem> + <para> + Execute the vacuum or analyze commands in parallel by running + <replaceable class="parameter">njobs</replaceable> + commands simultaneously. This option reduces the time of the + processing but it also increases the load on the database server. + </para> + <para> + <application>vacuumdb</application> will open + <replaceable class="parameter">njobs</replaceable> connections to the + database, so make sure your <xref linkend="guc-max-connections"> + setting is high enough to accommodate all connections. + </para> + <para> + Note that using this mode together with the <option>-f</option> + (<literal>FULL</literal>) option might cause deadlock failures if + certain system catalogs are processed in parallel. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--analyze-in-stages</option></term> <listitem> <para> |