diff options
| author | Bruce Momjian <bruce@momjian.us> | 2012-12-26 19:26:30 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2012-12-26 19:26:30 -0500 |
| commit | 6f1b9e4efd94fc644f5de5377829d42e48c3c758 (patch) | |
| tree | 82a38873d737a5ced39485bccfb25aa0927723dc /doc/src | |
| parent | 3f88b080030682adf359248c9cb7f8b2068a539e (diff) | |
| download | postgresql-6f1b9e4efd94fc644f5de5377829d42e48c3c758.tar.gz postgresql-6f1b9e4efd94fc644f5de5377829d42e48c3c758.zip | |
Add pg_upgrade --jobs parameter
Add pg_upgrade --jobs, which allows parallel dump/restore of databases,
which improves performance.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/pgupgrade.sgml | 18 |
1 files changed, 15 insertions, 3 deletions
diff --git a/doc/src/sgml/pgupgrade.sgml b/doc/src/sgml/pgupgrade.sgml index 998cb2fc9a5..53781e45ed6 100644 --- a/doc/src/sgml/pgupgrade.sgml +++ b/doc/src/sgml/pgupgrade.sgml @@ -113,6 +113,13 @@ </varlistentry> <varlistentry> + <term><option>-j</option></term> + <term><option>--jobs</option></term> + <listitem><para>number of simultaneous processes or threads to use + </para></listitem> + </varlistentry> + + <varlistentry> <term><option>-k</option></term> <term><option>--link</option></term> <listitem><para>use hard links instead of copying files to the new cluster</para></listitem> @@ -331,10 +338,15 @@ NET STOP pgsql-8.3 (<productname>PostgreSQL</> 8.3 and older used a different s requires that the old and new cluster data directories be in the same file system. See <literal>pg_upgrade --help</> for a full list of options. - </para> + </para> - <para> - </para> + <para> + The <option>--jobs</> option allows multiple CPU cores to be used + to dump and reload database schemas in parallel; a good place to + start is the number of CPU cores on the server. This option can + dramatically reduce the time to upgrade a multi-database server + running on a multiprocessor machine. + </para> <para> For Windows users, you must be logged into an administrative account, and |