See Reduce main database load by optimizing `deploy... (&10169)
https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#drop-indexes-asynchronously