Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3c472a1

Browse files
doc: Adjust note about pg_upgrade's --jobs option.
Presently, this section lists a couple of parallelized parts ofpg_upgrade and suggests a starting point for setting the --jobsoption. The list of parallelized tasks is not particularlyactionable, and the phrasing for the --jobs recommendation isconfusing to some readers.This commit attempts to improve this section by eliminating thelist of parallelized tasks and instead highlighting that --jobs ismost useful for clusters with multiple databases or tablespaces.Additionally, the recommendation for setting --jobs is simplifiedto suggest starting with the number of CPU cores.Reported-by: Magnus Hagander <magnus@hagander.net>Reviewed-by: Daniel Gustafsson <daniel@yesql.se>Reviewed-by: Magnus Hagander <magnus@hagander.net>Discussion:https://postgr.es/m/Z8dBn_5iGLNuYiPo%40nathan
1 parent1852aea commit3c472a1

File tree

1 file changed

+5
-6
lines changed

1 file changed

+5
-6
lines changed

‎doc/src/sgml/ref/pgupgrade.sgml

Lines changed: 5 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -533,12 +533,11 @@ NET STOP postgresql-&majorversion;
533533
</para>
534534

535535
<para>
536-
The <option>--jobs</option> option allows multiple CPU cores to be used
537-
for copying/linking of files, dumping and restoring database schemas
538-
in parallel, etc.; a good place to start is the maximum of the number of
539-
CPU cores and tablespaces. This option can dramatically reduce the
540-
time to upgrade a multi-database server running on a multiprocessor
541-
machine.
536+
Setting <option>--jobs</option> to 2 or higher allows pg_upgrade to
537+
process multiple databases and tablespaces in parallel. A good starting
538+
point is the number of CPU cores on the machine. This option can
539+
substantially reduce the upgrade time for multi-database and
540+
multi-tablespace servers.
542541
</para>
543542

544543
<para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp