|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.194 2003/07/22 20:29:13 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.195 2003/07/23 20:30:35 momjian Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <Chapter Id="runtime"> |
@@ -887,7 +887,9 @@ SET ENABLE_SEQSCAN TO OFF; |
887 | 887 | times the value of <varname>SORT_MEM</varname>. Sort operations are used |
888 | 888 | by <literal>ORDER BY</>, merge joins, and <command>CREATE INDEX</>. |
889 | 889 | Hash tables are used in hash joins, hash-based aggregation, and |
890 | | - hash-based processing of <literal>IN</> subqueries. |
| 890 | + hash-based processing of <literal>IN</> subqueries. Because |
| 891 | + <command>CREATE INDEX</> is used when restoring a database, it might |
| 892 | + be good to temporary increase this value during a restore. |
891 | 893 | </para> |
892 | 894 | </listitem> |
893 | 895 | </varlistentry> |
|