diff options
| author | Jani Välimaa <wally@mageia.org> | 2025-05-11 12:52:59 +0300 |
|---|---|---|
| committer | Jani Välimaa <wally@mageia.org> | 2025-05-11 12:52:59 +0300 |
| commit | fe776b78e4da36b5df8f842ac3f39e7244da2cc4 (patch) | |
| tree | 4f8f7c7fcafdf72feadd1d89228e71f6313ed999 | |
| parent | 63750daa63f07dc57e5a95d3343452f58a48f7f6 (diff) | |
| download | puppet-fe776b78e4da36b5df8f842ac3f39e7244da2cc4.tar puppet-fe776b78e4da36b5df8f842ac3f39e7244da2cc4.tar.gz puppet-fe776b78e4da36b5df8f842ac3f39e7244da2cc4.tar.bz2 puppet-fe776b78e4da36b5df8f842ac3f39e7244da2cc4.tar.xz puppet-fe776b78e4da36b5df8f842ac3f39e7244da2cc4.zip | |
Tune more PostgreSQL memory parameters
| -rw-r--r-- | modules/postgresql/templates/postgresql.conf | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/modules/postgresql/templates/postgresql.conf b/modules/postgresql/templates/postgresql.conf index bc13ace4..89efcd58 100644 --- a/modules/postgresql/templates/postgresql.conf +++ b/modules/postgresql/templates/postgresql.conf @@ -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 = 1MB # min 64kB -#maintenance_work_mem = 16MB # min 1MB +work_mem = 80MB # min 64kB +maintenance_work_mem = 1536MB # min 1MB #max_stack_depth = 2MB # min 100kB # - Kernel Resource Usage - @@ -235,7 +235,7 @@ shared_buffers = 4096MB # min 128kB #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 = 128MB +effective_cache_size = 8096MB # - Genetic Query Optimizer - |