Skip to content

Trigram db index for runner version field

Markus Ferrell requested to merge markus.ferrell/gitlab:runner_version_database_index into master

What does this MR do and why?

Creates database trigram index for the version column of the ci_runners table. This index allows for faster indexing when referencing versions with ILIKE.

This preliminary MR was requested for !118829 (merged) with this note.

How to set up and validate locally

  1. Migrate your database to apply the new index: bin/rails db:migrate RAILS_ENV=development
  2. Open psql with gdk psql
  3. Search for the index with \d index_ci_runners_on_version_trigram

You should see the following output:

image

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Markus Ferrell

Merge request reports