> 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?
+1 (and can we do the other koji instances that are in ansible too -
IE arm and s390 if they weren't done last time?)
_______________________________________________
infrastructure mailing list
[email protected]
http://lists.fedoraproject.org/admin/lists/[email protected]
