Change in ovirt-engine[master]: packaging: setup: More aggressive autovacuum configuration
From Sandro Bonazzola <sbonazzo(a)redhat.com>:
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>
---
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>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Jenkins CI
Gerrit-Reviewer: Martin Peřina <mperina(a)redhat.com>
Gerrit-Reviewer: Michal Skrivanek <michal.skrivanek(a)redhat.com>
Gerrit-Reviewer: Roy Golan <rgolan(a)redhat.com>
Gerrit-Reviewer: Sandro Bonazzola <sbonazzo(a)redhat.com>
Gerrit-Reviewer: Yedidyah Bar David <didi(a)redhat.com>
Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org>