Replace issues and merge requests trigram indexes with constrained indexes for `deleted_at`
What does this MR do?
Replace issues and merge requests trigram indexes with constrained indexes to improve performance
Are there points in the code the reviewer needs to double check?
Is deleting and recreating these indexes doable in production? Should we just add the new indexes instead of replace the old ones?
Why was this MR needed?
The issues query is one of the most time consuming of all
What are the relevant issue numbers?
Relevant links
Here's the plan on my local machine for the query in #14712 (closed) visualized: https://explain.depesz.com/s/rtef