Emergency FBR: Lower concurrency on postgres to help load

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Currently the load on db-koji is 140+ and it is slow and
non-responsive to users. I believe it is the below change which has
affected this. I would like to lower down io to 32 to see if that
affects things and tune further if needed. I am not doing this until
Kevin or Patrick are around as it will affect koji and there is an
order needed

diff --git a/roles/postgresql_server/templates/postgresql.conf
b/roles/postgresql_server/templates/postgresql.conf
index cbaaaae..341340c 100644
--- a/roles/postgresql_server/templates/postgresql.conf
+++ b/roles/postgresql_server/templates/postgresql.conf
@@ -504,4 +504,4 @@ default_text_search_config = 'pg_catalog.english'
 #custom_variable_classes = ''           # list of custom variable class names
 #
 # Number of concurrent i/o operations at the same time. The default is 1.
-effective_io_concurrency = 100
+effective_io_concurrency = 32


-- 
Stephen J Smoogen.
_______________________________________________
infrastructure mailing list -- infrastructure@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to infrastructure-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@xxxxxxxxxxxxxxxxxxxxxxx




[Index of Archives]     [Fedora Development]     [Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [KDE Users]

  Powered by Linux