diff options
| author | Kevin Fenzi <kevin@scrye.com> | 2016-03-15 03:02:30 +0000 |
|---|---|---|
| committer | Kevin Fenzi <kevin@scrye.com> | 2016-03-15 03:02:30 +0000 |
| commit | f1d26dda17cfe4fca05210ffdd677d2c4fd185a7 (patch) | |
| tree | 5bde9380cc760f54b0fe73008634aaefda9138a1 /roles/postgresql_server | |
| parent | a85f7ce208489f471ef2c597117ab2c969723eb1 (diff) | |
| download | ansible-f1d26dda17cfe4fca05210ffdd677d2c4fd185a7.tar.gz ansible-f1d26dda17cfe4fca05210ffdd677d2c4fd185a7.tar.xz ansible-f1d26dda17cfe4fca05210ffdd677d2c4fd185a7.zip | |
Tweak postgresql settings for db-koji01
Diffstat (limited to 'roles/postgresql_server')
| -rw-r--r-- | roles/postgresql_server/templates/postgresql.conf | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/roles/postgresql_server/templates/postgresql.conf b/roles/postgresql_server/templates/postgresql.conf index 603f9ea61..4a8bdfb74 100644 --- a/roles/postgresql_server/templates/postgresql.conf +++ b/roles/postgresql_server/templates/postgresql.conf @@ -121,8 +121,13 @@ shared_buffers = {{ shared_buffers }} # min 128kB or max_connections*16kB # 8 MB is probably on the high side. We can probably do with 4MB. But we # were seeing a problem and we have the RAM so we're going to try this. -work_mem = 2MB # min 64kB -maintenance_work_mem = 1024MB # min 1MB +{% if ansible_hostname.startswith("db-koji01") %} +work_mem = 4MB # min 64kB +maintenance_work_mem = 16MB # min 1MB +{% else %} +work_mem = 2MB # min 64kB +maintenance_work_mem = 1024MB # min 1MB +{% endif %} #max_stack_depth = 2MB # min 100kB # - Free Space Map - @@ -215,7 +220,11 @@ random_page_cost = 3.0 # same scale as above #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 +{% if ansible_hostname.startswith("db-koji01") %} +effective_cache_size = 24GB +{% else %} effective_cache_size = 5GB +{% endif %} # - Genetic Query Optimizer - |