diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2015-01-23 15:02:45 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2015-01-23 15:02:45 -0300 |
| commit | a17923204736d8842eade3517d6a8ee81290fca4 (patch) | |
| tree | 5e7c05d028e03a28cc013a2d06b7e46f73134cda /doc/src | |
| parent | 5cefbf5a6c4466ac6b1cc2a4316b4eba9108c802 (diff) | |
vacuumdb: enable parallel mode
This mode allows vacuumdb to open several server connections to vacuum
or analyze several tables simultaneously.
Author: Dilip Kumar. Some reworking by Álvaro Herrera
Reviewed by: Jeff Janes, Amit Kapila, Magnus Hagander, Andres Freund
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> |