diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-09-17 21:41:47 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-09-17 21:41:47 +0000 |
| commit | 445732a5ff19f34f7d3675fc64d63d03bf6467e0 (patch) | |
| tree | 90257c802022aaefd4dbfbf8e408ee048f853a1f /doc/src | |
| parent | aef9dbdb376242471b73f371b039627d7f63f27d (diff) | |
| download | postgresql-445732a5ff19f34f7d3675fc64d63d03bf6467e0.tar.gz postgresql-445732a5ff19f34f7d3675fc64d63d03bf6467e0.zip | |
Point out that CREATE INDEX uses sorts and hence sort_mem GUC parameter.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 6d1d3e17906..b993323db61 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.135 2002/09/02 13:45:30 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.136 2002/09/17 21:41:47 momjian Exp $ --> <Chapter Id="runtime"> @@ -1784,12 +1784,13 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' Specifies the amount of memory to be used by internal sorts and hashes before switching to temporary disk files. The value is specified in kilobytes, and defaults to 1024 kilobytes (1MB). - Note that for a complex query, several sorts and/or hashes might be - running in parallel, and each one will be allowed to use as much - memory as this value specifies before it starts to put data into - temporary files. Also, each running backend could be doing one - or more sorts simultaneously, so the total memory used could be - many times the value of <varname>SORT_MEM</varname>. + Note that for a complex query, several sorts might be running in + parallel, and each one will be allowed to use as much memory as + this value specifies before it starts to put data into temporary + files. Also, each running backend could be doing one or more + sorts simultaneously, so the total memory used could be many + times the value of <varname>SORT_MEM</varname>. Sorts are used + by ORDER BY, merge joins, and CREATE INDEX. </para> </listitem> </varlistentry> |