Skip to content

graphqlbackend: Optimize repo query for lang suggestions

Administrator requested to merge core/fix-6760 into master

Created by: tsenart

This commit optimizes the SQL query used to find a repo for language suggestions.

  • It removes everything from the last @ in the repo name, since it prevented Postgres from using its trigram index on the name column of the repo table.
  • It changes the operator we use to perform regex matching on the name column from ~* (case insenstive) to ~ case senstive.

Fixes #6760

Merge request reports