Bugzilla (bugzilla.redhat.com) will be under maintenance for infrastructure upgrades and will not be available on July 31st between 12:30 AM - 05:30 AM UTC. We appreciate your understanding and patience. You can follow status.redhat.com for details.
Bug 1270584 - engine database has some missing indexes
Summary: engine database has some missing indexes
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Backend.Core
Version: 3.6.0
Hardware: Unspecified
OS: Unspecified
Target Milestone: ovirt-3.6.1
: 3.6.1
Assignee: Eli Mesika
QA Contact: Lukas Svaty
Depends On:
TreeView+ depends on / blocked
Reported: 2015-10-11 13:05 UTC by Eli Mesika
Modified: 2016-02-18 11:06 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Last Closed: 2016-02-18 11:06:18 UTC
oVirt Team: Infra
ylavi: ovirt-3.6.z?
rule-engine: planning_ack?
oourfali: devel_ack+
pstehlik: testing_ack+

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
oVirt gerrit 47179 0 master MERGED db: add missing indexes: Never
oVirt gerrit 47214 0 ovirt-engine-3.6 MERGED db: add missing indexes: Never

Description Eli Mesika 2015-10-11 13:05:28 UTC
Description of problem:

PostgreSQL automatically creates indexes on primary keys and unique
constraints, but not on the referencing side of foreign key

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

Since oVirt mainly use the database for read operations, this may boost database performance

Comment 1 Red Hat Bugzilla Rules Engine 2015-10-19 10:56:58 UTC
Target release should be placed once a package build is known to fix a issue. Since this bug is not modified, the target version has been reset. Please use target milestone to plan a fix for a oVirt release.

Comment 2 Yaniv Lavi 2015-10-29 12:39:45 UTC
In oVirt testing is done on single release by default. Therefore I'm removing the 4.0 flag. If you think this bug must be tested in 4.0 as well, please re-add the flag. Please note we might not have testing resources to handle the 4.0 clone.

Comment 3 Lukas Svaty 2016-01-21 15:09:23 UTC
DB logs since previous versions does not contain any related issues. Performance of database queries did not decrease. Putting this bug to verified as sanity should be sufficient for this Code Change. Tested on rhevm-

Note You need to log in before you can comment on or make changes to this bug.