Re-prepare async index on merge_request_commits_metadata_id

Patrick Bajaorequested to merge
527227-reprepare-async-index into master

What does this MR do and why?

We previously added this in !188985 (merged) but we made it no-op in !189591 (merged) due to a typo.

This re-prepares the async index but this time with the correct column name.

When I ran a test of CREATE INDEX CONCURRENTLY in postgres.ai to see how long it'll take to create this, it took 562.211 min (I ran this last 2025-04-23). Here's a link to the execution: https://console.postgres.ai/gitlab/gitlab-production-main/sessions/38719/commands/119154 (please take note when I ran this, I had the column in the table on postgres.ai as merge_request_commit_metadata_id (without the s) but that was just for testing).

References

Related to #527227

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Patrick Bajao

Merge request reports