Change in ovirt-engine[master]: core: CalculateStorageUsage psql function refactoring.
Allon Mureinik has submitted this change and it was merged.
Change subject: core: CalculateStorageUsage psql function refactoring.
......................................................................
core: CalculateStorageUsage psql function refactoring.
CalculateStorageUsage psql function was joining tables that were already
joined by images_storage_domain_view, also- executed almost the same query
twice- while it could be consolidated into one query by adding a simple
condition.
This patch changes the query to select only from
images_storage_domain_view, and consolidating the two queries.
Change-Id: I3997cb4f310ca8ebaf8d36f9ffae1d126fa7de00
Signed-off-by: Amit Aviram <aaviram(a)redhat.com>
---
M packaging/dbscripts/create_functions.sql
1 file changed, 9 insertions(+), 20 deletions(-)
Approvals:
Jenkins CI: Passed CI tests
Amit Aviram: Verified
Allon Mureinik: Looks good to me, approved
Maor Lipchuk: Looks good to me, approved
--
To view, visit https://gerrit.ovirt.org/48309
To unsubscribe, visit https://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I3997cb4f310ca8ebaf8d36f9ffae1d126fa7de00
Gerrit-PatchSet: 7
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Amit Aviram <aaviram(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Amit Aviram <aaviram(a)redhat.com>
Gerrit-Reviewer: Daniel Erez <derez(a)redhat.com>
Gerrit-Reviewer: Jenkins CI
Gerrit-Reviewer: Maor Lipchuk <mlipchuk(a)redhat.com>
Gerrit-Reviewer: Roy Golan <rgolan(a)redhat.com>
Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org>