Remove redundant index_releases_on_author_id
What does this MR do and why?
We recently added index on (author_id, id, created_at), so index on (author_id) is redundant now.
Migration logs
vlad @ gdk1 ➜ gitlab git:(342385-remove-redundant-index_releases_on_author_id) ✗ ./bin/rails db:migrate
== 20211026143238 RemoveIndexReleasesOnAuthorId: migrating ====================
-- transaction_open?()
-> 0.0000s
-- indexes(:releases)
-> 0.0110s
-- execute("SET statement_timeout TO 0")
-> 0.0011s
-- remove_index(:releases, {:algorithm=>:concurrently, :name=>"index_releases_on_author_id"})
-> 0.0076s
-- execute("RESET statement_timeout")
-> 0.0012s
== 20211026143238 RemoveIndexReleasesOnAuthorId: migrated (0.0386s) ===========
vlad @ gdk1 ➜ gitlab git:(342385-remove-redundant-index_releases_on_author_id) ✗ ./bin/rails db:rollback
== 20211026143238 RemoveIndexReleasesOnAuthorId: reverting ====================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:releases, [:author_id], {:name=>"index_releases_on_author_id", :algorithm=>:concurrently})
-> 0.0065s
-- execute("SET statement_timeout TO 0")
-> 0.0014s
-- add_index(:releases, [:author_id], {:name=>"index_releases_on_author_id", :algorithm=>:concurrently})
-> 0.0081s
-- execute("RESET statement_timeout")
-> 0.0016s
== 20211026143238 RemoveIndexReleasesOnAuthorId: reverted (0.0230s) ===========
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #342385 (closed)
Edited by Vladimir Shushlin