Liran Zelkha has uploaded a new change for review. Change subject: core: Create a permission_view materialized view ......................................................................
core: Create a permission_view materialized view Since permission_view is highly used, we've migrated it to be a materialized view to improve performance. Change-Id: I5c05f4fa074fb3183d15dba247509f6474be9ff7 Signed-off-by: [email protected] <[email protected]> --- M backend/manager/dbscripts/upgrade/post_upgrade/0020_create_materialized_views.sql 1 file changed, 23 insertions(+), 8 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/68/16068/1 diff --git a/backend/manager/dbscripts/upgrade/post_upgrade/0020_create_materialized_views.sql b/backend/manager/dbscripts/upgrade/post_upgrade/0020_create_materialized_views.sql index 587981d..08efc26 100644 --- a/backend/manager/dbscripts/upgrade/post_upgrade/0020_create_materialized_views.sql +++ b/backend/manager/dbscripts/upgrade/post_upgrade/0020_create_materialized_views.sql @@ -1,14 +1,7 @@ /****************************************************************************************************** Snapshot Materialized Views Definitions Section ******************************************************************************************************/ - - - - - - - - +select CreateMaterializedViewAs('permissions_view',300); /****************************************************************************************************** Snapshot Materialized Views Index Definitions Section @@ -18,3 +11,25 @@ MtDropmy_mtIndexes - Drops indexes on my_mt MtCreatemy_mtIndexes - Creates needed indexes on my_mt ******************************************************************************************************/ + +create or replace function MtCreatepermissions_viewIndexes() +returns void +as $procedure$ +begin +create index permissions_view_object_index on permissions_view (object_id); +create index permissions_view_index on permissions_view (id); +create index permissions_view_role_index on permissions_view (role_id); +end; $procedure$ +language plpgsql; + +create or replace function MtDroppermissions_viewIndexes() +returns void +as $procedure$ +begin +drop index if exists permissions_view_object_index cascade; +drop index if exists permissions_view_index cascade; +drop index if exists permissions_view_role_index cascade; +end; $procedure$ +language plpgsql; + +select RefreshMaterializedView('permissions_view'); \ No newline at end of file -- To view, visit http://gerrit.ovirt.org/16068 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I5c05f4fa074fb3183d15dba247509f6474be9ff7 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Liran Zelkha <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
