Prepare partial issue trigram indexes
What does this MR do and why?
Prepares the indexes in !92739 (merged) to be created on the weekend.
Running these manually on dblab took 6+ hours:
gitlabhq_dblab=# CREATE INDEX index_issues_on_title_trigram_non_english ON issues USING gin (title gin_trgm_ops) WHERE (title NOT SIMILAR TO '[\u0000-\u218F]*' OR description NOT SIMILAR TO '[\u0000-\u218F]*');
CREATE INDEX
Time: 4621364.064 ms (01:17:01.364)
gitlabhq_development=# CREATE INDEX index_issues_on_description_trigram_non_english ON issues USING gin (description gin_trgm_ops) WHERE (title NOT SIMILAR TO '[\u0000-\u218F]*' OR description NOT SIMILAR TO '[\u0000-\u218F]*');
CREATE INDEX
Time: 19375673.288 ms (05:22:55.673)
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #364556 (closed)
Edited by Heinrich Lee Yu