From Eli Mesika <emesika@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@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@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Moti Asayag <masayag@redhat.com> Gerrit-Reviewer: gerrit-hooks <automation@ovirt.org>