Change in ovirt-engine[master]: db: move permission data changes to SP call
From Eli Mesika <emesika(a)redhat.com>:
Eli Mesika has submitted this change and it was merged. ( https://gerrit.ovirt.org/79287
)
Change subject: db: move permission data changes to SP call
......................................................................
db: move permission data changes to SP call
Postgres 9.3 introduced Materialized Views support.
In order to use that in oVirt we need to find out which views are
relatively complex and have a low data change rate.
The *permissions* views are a natural candidate for that, but before
that we need to change all direct changes on the permission table to use
a SP call in order to refresh the materialized views in one place.
This patch changes all data changes to use a SP call.
Change-Id: I4fb7cbdae37083b60938195256257cf848f133c0
Signed-off-by: emesika <emesika(a)redhat.com>
---
M packaging/dbscripts/base_disks_sp.sql
M packaging/dbscripts/clusters_sp.sql
M packaging/dbscripts/common_sp.sql
M packaging/dbscripts/cpu_profiles_sp.sql
M packaging/dbscripts/disk_profiles_sp.sql
M packaging/dbscripts/multi_level_administration_sp.sql
M packaging/dbscripts/network_sp.sql
M packaging/dbscripts/storages_sp.sql
M packaging/dbscripts/vds_sp.sql
M packaging/dbscripts/vm_pools_sp.sql
M packaging/dbscripts/vm_templates_sp.sql
M packaging/dbscripts/vms_sp.sql
12 files changed, 32 insertions(+), 82 deletions(-)
Approvals:
Martin Peřina: Looks good to me, but someone else must approve
Eli Mesika: Verified
Jenkins CI: Passed CI tests
Allon Mureinik: Looks good to me, but someone else must approve
Moti Asayag: Looks good to me, approved
--
To view, visit https://gerrit.ovirt.org/79287
To unsubscribe, visit https://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I4fb7cbdae37083b60938195256257cf848f133c0
Gerrit-PatchSet: 5
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(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: Moti Asayag <masayag(a)redhat.com>
Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org>