Greetings.
I was going to wait until after freeze to mess with the other
postgresql hosts, but then mattdm pointed out this morning that
hyperkitty is really slow currently. I'm not sure this will help, but
it really make db-koji01 a great deal happier and it should be pretty
easy to revert if needed.
So, I'd like to make the same changes that made db-koji01 happy to
db01:
diff --git a/roles/postgresql_server/templates/postgresql.conf b/roles/postgresql_server/templates/postgresql.conf
index 4a8bdfb..de9f1f0 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 -
+1s?
kevin
Attachment:
pgplgp_zX22S7.pgp
Description: OpenPGP digital signature
_______________________________________________ infrastructure mailing list infrastructure@xxxxxxxxxxxxxxxxxxxxxxx http://lists.fedoraproject.org/admin/lists/infrastructure@xxxxxxxxxxxxxxxxxxxxxxx
