diff options
| author | Jani Välimaa <wally@mageia.org> | 2025-05-11 13:06:15 +0300 |
|---|---|---|
| committer | Jani Välimaa <wally@mageia.org> | 2025-05-11 13:06:15 +0300 |
| commit | 64a8dc1c3e3ef6ff8f824ec518110c36ccf9bd11 (patch) | |
| tree | bef94d4e3e4b9829ad7dac48d341527d773e00b5 /modules/postgresql | |
| parent | e802a71f4cba56418ef7d71503cc0038dcd9a2bf (diff) | |
| download | puppet-master.tar puppet-master.tar.gz puppet-master.tar.bz2 puppet-master.tar.xz puppet-master.zip | |
Diffstat (limited to 'modules/postgresql')
| -rw-r--r-- | modules/postgresql/templates/postgresql.conf | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/modules/postgresql/templates/postgresql.conf b/modules/postgresql/templates/postgresql.conf index 97e42cd2..c1e7c994 100644 --- a/modules/postgresql/templates/postgresql.conf +++ b/modules/postgresql/templates/postgresql.conf @@ -113,7 +113,7 @@ ssl = on # - Memory - -shared_buffers = 4096MB # min 128kB +shared_buffers = 2048MB # min 128kB # (change requires restart) #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 0 # zero disables the feature @@ -122,8 +122,8 @@ shared_buffers = 4096MB # min 128kB # 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 = 80MB # min 64kB -maintenance_work_mem = 1536MB # min 1MB +work_mem = 64MB # min 64kB +maintenance_work_mem = 512MB # min 1MB #max_stack_depth = 2MB # min 100kB # - Kernel Resource Usage - @@ -235,7 +235,7 @@ maintenance_work_mem = 1536MB # min 1MB #cpu_tuple_cost = 0.01 # same scale as above #cpu_index_tuple_cost = 0.005 # same scale as above #cpu_operator_cost = 0.0025 # same scale as above -effective_cache_size = 8192MB +effective_cache_size = 4096MB # - Genetic Query Optimizer - |