Implement title/description search with Elasticsearch
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
We are dropping index_merge_requests_on_description_trigram and index_merge_requests_on_title_trigram gin indexes in https://gitlab.com/gitlab-org/gitlab/-/issues/554568 as those indexes were high WAL rate contributors and are not used very much.
Although these indexes didn't seem to be used much when performing full text search in MR search pages at .com scale, but it may be useful in much smaller self-managed instances so we only dropped these for .com.
However, since these search never really worked well, we should look into utilizing ElasticSearch to provide these search functionality. MR title and description are already a part of Advanced search so we should be able to utilize some of the existing code.
Once that's done we could consider dropping these indexes for self-managed instances as well and encourage them to adopt Elasticsearch if they want more performant search.