Trigram db index for runner version field
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
- Migrate your database to apply the new index:
bin/rails db:migrate RAILS_ENV=development
- Open psql with
gdk psql
- Search for the index with
\d index_ci_runners_on_version_trigram
You should see the following output:
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.
Edited by Markus Ferrell