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 <astieger@suse.com> 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 <hvogel@opensuse.org> 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...