Missing/extra indexes in schema.rb
Some indexes are not present in schema.rb but are present in gitlab.com. These should have migrations added to ensure they're present on every install (or they should be removed from gitlab.com). Some indexes are present in schema.rb but missing in gitlab.com! These should be investigated and created in gitlab.com.
List of such indexes:
-
CREATE INDEX index_notes_on_updated_at ON notes USING btree (updated_at); Missing on gitlab.com https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/23356 -
CREATE INDEX index_for_ci_builds_retried_migration ON ci_builds USING btree (id) WHERE (retried IS NULL) -
DROP INDEX index_merge_requests_on_source_project_id_and_source_branch; - Missing in schema.rb
-
index_push_rules_is_sample
Edited by Lin Jen-Shin