diff options
| author | Bruce Momjian <bruce@momjian.us> | 2014-02-24 13:04:51 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2014-02-24 13:04:51 -0500 |
| commit | 848ae330a497b4d430d93bd813f93c40d2bb0157 (patch) | |
| tree | 04cc910fd46df10ccfdedb263ab7588b98f60767 /doc/src | |
| parent | 6f14a6f703a26ec12f4da6f53f107dd260fbb9db (diff) | |
| download | postgresql-848ae330a497b4d430d93bd813f93c40d2bb0157.tar.gz postgresql-848ae330a497b4d430d93bd813f93c40d2bb0157.zip | |
Increase work_mem and maintenance_work_mem defaults by 4x
New defaults are 4MB and 64MB.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 4dc1277f252..91a601559f0 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1213,7 +1213,7 @@ include 'filename' <para> Specifies the amount of memory to be used by internal sort operations and hash tables before writing to temporary disk files. The value - defaults to one megabyte (<literal>1MB</>). + defaults to four megabytes (<literal>4MB</>). Note that for a complex query, several sort or hash operations might be running in parallel; each operation will be allowed to use as much memory as this value specifies before it starts to write data into temporary @@ -1239,7 +1239,7 @@ include 'filename' Specifies the maximum amount of memory to be used by maintenance operations, such as <command>VACUUM</command>, <command>CREATE INDEX</>, and <command>ALTER TABLE ADD FOREIGN KEY</>. It defaults - to 16 megabytes (<literal>16MB</>). Since only one of these + to 64 megabytes (<literal>64MB</>). Since only one of these operations can be executed at a time by a database session, and an installation normally doesn't have many of them running concurrently, it's safe to set this value significantly larger |