diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-07-23 20:30:35 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-07-23 20:30:35 +0000 |
| commit | 0221bc97cf8722ef5c8107da4e5d9e25aa8a93af (patch) | |
| tree | c524b9f4fab2bc77e459f14fc11608ec55838166 | |
| parent | 7d06fc01e378f11b14260e967496c8847c92d329 (diff) | |
| download | postgresql-0221bc97cf8722ef5c8107da4e5d9e25aa8a93af.tar.gz postgresql-0221bc97cf8722ef5c8107da4e5d9e25aa8a93af.zip | |
Mention increasing sort_mem during a restore.
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index bab8d2751d4..1f28e21559f 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.194 2003/07/22 20:29:13 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.195 2003/07/23 20:30:35 momjian Exp $ --> <Chapter Id="runtime"> @@ -887,7 +887,9 @@ SET ENABLE_SEQSCAN TO OFF; times the value of <varname>SORT_MEM</varname>. Sort operations are used by <literal>ORDER BY</>, merge joins, and <command>CREATE INDEX</>. Hash tables are used in hash joins, hash-based aggregation, and - hash-based processing of <literal>IN</> subqueries. + hash-based processing of <literal>IN</> subqueries. Because + <command>CREATE INDEX</> is used when restoring a database, it might + be good to temporary increase this value during a restore. </para> </listitem> </varlistentry> |