Change in ovirt-engine[ovirt-engine-3.6]: db: add missing indexes:
Tal Nisan has submitted this change and it was merged.
Change subject: db: add missing indexes:
......................................................................
db: add missing indexes:
This patch includes missing indexes suggested by pgcluu
(http://pgcluu.darold.net/)
PostgreSQL automatically creates indexes on primary keys and unique
constraints, but not on the referencing side of foreign key
relationships.
Since a DELETE of a row from the referenced table or an UPDATE of a
referenced column will require a scan of the referencing table for rows
matching the old value, it is often a good idea to index the referencing
columns.
Change-Id: I09b43335e7cde29235839df00f590fef346d3547
Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=1270584
Signed-off-by: emesika <emesika(a)redhat.com>
---
A packaging/dbscripts/upgrade/03_06_1880_add_index_to_fk_columns.sql
1 file changed, 91 insertions(+), 0 deletions(-)
Approvals:
Tal Nisan: Passed CI tests
Eli Mesika: Verified; Looks good to me, approved
Objections:
Jenkins CI: Failed CI tests
--
To view, visit https://gerrit.ovirt.org/47214
To unsubscribe, visit https://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I09b43335e7cde29235839df00f590fef346d3547
Gerrit-PatchSet: 3
Gerrit-Project: ovirt-engine
Gerrit-Branch: ovirt-engine-3.6
Gerrit-Owner: Eli Mesika <emesika(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: Oved Ourfali <oourfali(a)redhat.com>
Gerrit-Reviewer: Tal Nisan <tnisan(a)redhat.com>
Gerrit-Reviewer: automation(a)ovirt.org