Branch: refs/heads/master
Home: https://github.com/openSUSE/open-build-service
Commit: 2493155fb20efacb4fd9eb74b70796c359a0348f
https://github.com/openSUSE/open-build-service/commit/2493155fb20efacb4fd9eb...
Author: Andreas Stieger
Date: 2017-02-03 (Fri, 03 Feb 2017)
Changed paths:
A src/api/db/migrate/20170123115500_remove_duplicate_indexes.rb
M src/api/db/structure.sql
Log Message:
-----------
[api] remove duplicate indexes
Remove duplicate indexes as suggested by pt-duplicate-key-checker.
A key or unique constraint on "a,b" is also an index on just "a".
Such duplicate indexes accumulate over the lifetime of a sw project
and do not normally hurt in production. However keeping them around
carries a performance penalty as all indexes need to be maintained
by the database engines.
If a previous database migration class was skipped or structure.sql
does not represent the current schema, this potentially removes
useful indexes - this would, however, be an operational problem.
* src/api/db/migrate/20170123115500_remove_duplicate_indexes.rb
Migration class
* structure.sql: changed my same DDL
Commit: a3e4c44462f5e9130437928fff8eb397bf4f46d4
https://github.com/openSUSE/open-build-service/commit/a3e4c44462f5e913043792...
Author: Henne Vogelsang
Date: 2017-02-03 (Fri, 03 Feb 2017)
Changed paths:
A src/api/db/migrate/20170123115500_remove_duplicate_indexes.rb
M src/api/db/structure.sql
Log Message:
-----------
Merge pull request #2597 from adrianschroeter/astieger
[api] remove duplicate indexes
Compare: https://github.com/openSUSE/open-build-service/compare/bbcdf577db23...a3e4c4...