Skip to content

Improve SBoM search performance with a inverted index

Michał Zając requested to merge mzajac/create-inverted-index-on-sbom_occurrences into master

What does this MR do and why?

Improve SBoM search performance with a inverted index. We had to Introduce minimum query length (#497530 - closed) because of poor performance with 1-2 characters but this index seems to improve the performance. Thanks to @ahegyi for the idea.

Database review

Old

https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32343/commands/99903

New

https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32343/commands/99939

Merge request reports