From Tal Nisan <tnisan@redhat.com>:

Tal Nisan 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@redhat.com> --- 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: Martin Peřina: Looks good to me, approved Jenkins CI: Passed CI tests Yedidyah Bar David: Looks good to me, but someone else must approve Roy Golan: Verified -- To view, visit https://gerrit.ovirt.org/70309 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I426de8d2903dc8430e14957738e04757eb4c7eb5 Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-4.1 Gerrit-Owner: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Piotr Kliczewski <piotr.kliczewski@gmail.com> Gerrit-Reviewer: Roy Golan <rgolan@redhat.com> Gerrit-Reviewer: Sandro Bonazzola <sbonazzo@redhat.com> Gerrit-Reviewer: Tal Nisan <tnisan@redhat.com> Gerrit-Reviewer: Yedidyah Bar David <didi@redhat.com> Gerrit-Reviewer: gerrit-hooks <automation@ovirt.org>