Closed requested to merge constrained-indexes into master
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?
Here's the plan on my local machine for the query in #14712 (closed) visualized: https://explain.depesz.com/s/rtef