diff options
Diffstat (limited to 'doc/src/sgml/ref/vacuumdb.sgml')
| -rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 48 |
1 files changed, 24 insertions, 24 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index e38c34aea37..92b8984b7a6 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -134,6 +134,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>-q</></term> <term><option>--quiet</></term> <listitem> @@ -204,30 +228,6 @@ 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> |