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
pgplmWQjgNrZJ.pgp
Description: OpenPGP digital signature
_______________________________________________ infrastructure mailing list infrastructure@lists.fedoraproject.org http://lists.fedoraproject.org/admin/lists/infrastructure@lists.fedoraproject.org
