aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2010-02-26 02:31:52 +0000
committerBruce Momjian <bruce@momjian.us>2010-02-26 02:31:52 +0000
commitca8e3a51a05b1265f36f82497b039d7783c3dd98 (patch)
tree421dc0bd785604d056d22f4681cef7ec1e84069f /doc/src
parent4f96ddd1d36f33831a8452a8f6f8f7d6a08f7cde (diff)
downloadpostgresql-ca8e3a51a05b1265f36f82497b039d7783c3dd98.tar.gz
postgresql-ca8e3a51a05b1265f36f82497b039d7783c3dd98.zip
Document pg_restore --jobs as a performance enhancement.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/perform.sgml7
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml
index 1a9f7c1452d..02c5071d2ae 100644
--- a/doc/src/sgml/perform.sgml
+++ b/doc/src/sgml/perform.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/perform.sgml,v 1.73 2010/01/15 09:18:59 heikki Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/perform.sgml,v 1.74 2010/02/26 02:31:52 momjian Exp $ -->
<chapter id="performance-tips">
<title>Performance Tips</title>
@@ -1027,7 +1027,10 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse;
possibly discarding many hours of processing. Depending on how
interrelated the data is, that might seem preferable to manual cleanup,
or not. <command>COPY</> commands will run fastest if you use a single
- transaction and have WAL archiving turned off.
+ transaction and have WAL archiving turned off.
+ <application>pg_restore</> also has a <option>--jobs</> option
+ which allows concurrent data loading and index creation, and has
+ the performance advantages of doing COPY in a single transaction.
</para>
</listitem>
<listitem>