From 848ae330a497b4d430d93bd813f93c40d2bb0157 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 24 Feb 2014 13:04:51 -0500 Subject: Increase work_mem and maintenance_work_mem defaults by 4x New defaults are 4MB and 64MB. --- doc/src/sgml/config.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'doc/src') 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' 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 (1MB). + defaults to four megabytes (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 VACUUM, CREATE INDEX, and ALTER TABLE ADD FOREIGN KEY. It defaults - to 16 megabytes (16MB). Since only one of these + to 64 megabytes (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 -- cgit v1.2.3