Sandro Bonazzola has submitted this change and it was merged. Change subject: packaging: setup: More aggressive autovacuum configuration ...................................................................... packaging: setup: More aggressive autovacuum configuration Configuring the autovacuum daemon to be more performant and aggressive. To make the daemon efficient we a) tell it to start working more frequent on small number of changes (vacuum_scale_factor), b) spin more workers as we have more then 3 tables which are updated frequently and we want to prevent from exhausting the vacuum cost on few tables and starving other tables from being vacuumed and c) raising the memory amount each worker have to the passes on the pages would be efficient and quick. Our v*_dynamic and v*_statistics tables (plus few more) are updated very frequently as part of our monitoring needs. Even though we keep on optimizing the amount of updates to the bare minimum we still have to make sure we don't starve any of those tables otherwise we are in the risk of bloating the db. Change-Id: I426de8d2903dc8430e14957738e04757eb4c7eb5 Bug-Url: https://bugzilla.redhat.com/1388433 Signed-off-by: Roy Golan <rgolan(a)redhat.com&gt; --- M packaging/setup/ovirt_engine_setup/engine_common/constants.py M packaging/setup/ovirt_engine_setup/engine_common/database.py M packaging/setup/plugins/ovirt-engine-common/ovirt-engine-common/provisioning/postgres.py M packaging/setup/plugins/ovirt-engine-provisiondb/ovirt-engine-common/provisioning/postgres.py 4 files changed, 124 insertions(+), 2 deletions(-) Approvals: Sandro Bonazzola: Looks good to me, approved Martin Peřina: Looks good to me, but someone else must approve Jenkins CI: Passed CI tests Roy Golan: Verified -- To view, visit https://gerrit.ovirt.org/68676 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I426de8d2903dc8430e14957738e04757eb4c7eb5 Gerrit-PatchSet: 9 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Roy Golan <rgolan(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Peřina <mperina(a)redhat.com&gt; Gerrit-Reviewer: Michal Skrivanek <michal.skrivanek(a)redhat.com&gt; Gerrit-Reviewer: Roy Golan <rgolan(a)redhat.com&gt; Gerrit-Reviewer: Sandro Bonazzola <sbonazzo(a)redhat.com&gt; Gerrit-Reviewer: Yedidyah Bar David <didi(a)redhat.com&gt; Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org&gt;