Remove sent_notifications.namespace_id index ASYNC

Mario Celirequested to merge
514591-remove-namespace-id-index-from-dot-com into master

What does this MR do and why?

The index was only created in .com and later decided that was not needed as we are only introducing it in the new partitioned table. So removing the index over the weekend only in .com

Index was originally introduced in !192636 (merged) I guess we could make the drop sync as it will check in self-hosted if the index exists before trying to drop it, but this way we make sure it only tries to do it in .com as it was never created in self-hosted

At the time of writing, the index size is 89GB, so it's a good win for the table size, it should have been dropped before

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.

Related to #514591 (closed)

Edited by Mario Celi

Merge request reports