Red Hat Bugzilla – Bug 1270584
engine database has some missing indexes
Last modified: 2016-02-18 06:06:18 EST
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
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.
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.
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-18.104.22.168-0.1.el6.noarch