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@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@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourfali@redhat.com> Gerrit-Reviewer: Tal Nisan <tnisan@redhat.com> Gerrit-Reviewer: automation@ovirt.org