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 /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 'src')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 4 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 86afde17de5..aa5a8757fa3 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -1773,7 +1773,7 @@ static struct config_int ConfigureNamesInt[] = GUC_UNIT_KB }, &work_mem, - 1024, 64, MAX_KILOBYTES, + 4096, 64, MAX_KILOBYTES, NULL, NULL, NULL }, @@ -1784,7 +1784,7 @@ static struct config_int ConfigureNamesInt[] = GUC_UNIT_KB }, &maintenance_work_mem, - 16384, 1024, MAX_KILOBYTES, + 65536, 1024, MAX_KILOBYTES, NULL, NULL, NULL }, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 480c9e9797e..07341e72a43 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -124,8 +124,8 @@ # per transaction slot, plus lock space (see max_locks_per_transaction). # It is not advisable to set max_prepared_transactions nonzero unless you # actively intend to use prepared transactions. -#work_mem = 1MB # min 64kB -#maintenance_work_mem = 16MB # min 1MB +#work_mem = 4MB # min 64kB +#maintenance_work_mem = 64MB # min 1MB #autovacuum_work_mem = -1 # min 1MB, or -1 to use maintenance_work_mem #max_stack_depth = 2MB # min 100kB #dynamic_shared_memory_type = posix # the default is the first option |