diff options
| author | Kevin Fenzi <kevin@scrye.com> | 2016-03-15 18:00:36 +0000 |
|---|---|---|
| committer | Kevin Fenzi <kevin@scrye.com> | 2016-03-15 18:00:36 +0000 |
| commit | ee6d457c84da3e0a5b5b380dd290302d67995f8b (patch) | |
| tree | bd24c707f823bb5a4568df85307915aa681ae48d /roles/postgresql_server | |
| parent | d78803b52928c6f6e5df9e99b4db42f4ea3ff85c (diff) | |
| download | ansible-ee6d457c84da3e0a5b5b380dd290302d67995f8b.tar.gz ansible-ee6d457c84da3e0a5b5b380dd290302d67995f8b.tar.xz ansible-ee6d457c84da3e0a5b5b380dd290302d67995f8b.zip | |
Adjust db01 postgresql config also.
Diffstat (limited to 'roles/postgresql_server')
| -rw-r--r-- | roles/postgresql_server/templates/postgresql.conf | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/roles/postgresql_server/templates/postgresql.conf b/roles/postgresql_server/templates/postgresql.conf index 4a8bdfb74..de9f1f0f5 100644 --- a/roles/postgresql_server/templates/postgresql.conf +++ b/roles/postgresql_server/templates/postgresql.conf @@ -124,6 +124,9 @@ shared_buffers = {{ shared_buffers }} # min 128kB or max_connections*16kB {% if ansible_hostname.startswith("db-koji01") %} work_mem = 4MB # min 64kB maintenance_work_mem = 16MB # min 1MB +{% elif ansible_hostname.startswith("db01") %} +work_mem = 4MB # min 64kB +maintenance_work_mem = 1024MB # min 1MB {% else %} work_mem = 2MB # min 64kB maintenance_work_mem = 1024MB # min 1MB @@ -222,8 +225,10 @@ random_page_cost = 3.0 # same scale as above #cpu_operator_cost = 0.0025 # same scale as above {% if ansible_hostname.startswith("db-koji01") %} effective_cache_size = 24GB +{% elif ansible_hostname.startswith("db01") %} +effective_cache_size = 12GB {% else %} -effective_cache_size = 5GB +effective_cache_size = 5GB {% endif %} # - Genetic Query Optimizer - |