Drop invalid index from postgres_async_indexes
Ref: #387301 (closed)
What does this MR do and why?
Following up !108823 (merged) where we referenced the wrong column when creating our index.
This MR removed our index from the async queue in order to unlock async index creation on production.
Database
https://console.postgres.ai/gitlab/gitlab-production-ci/sessions/14973/commands/52144
Feature.enable(:database_async_index_creation)
Feature.enable(:database_reindexing)
GITLAB_SIMULATE_SAAS=1 bin/rails db:migrate
bundle exec rails gitlab:db:reindex
GITLAB_SIMULATE_SAAS=1 bin/rails db:migrate
main: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrating ======
main: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrated (0.0978s)
ci: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrating ======
ci: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrated (0.0070s)
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.
Edited by Max Orefice