Skip to content

Prepare partial issue trigram indexes

Heinrich Lee Yu requested to merge 364556-issues-partial-gin-index-async into master

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.

Related to #364556 (closed)

Edited by Heinrich Lee Yu

Merge request reports