Improve performance of finding issues with/without labels (!1787) · Merge requests · GitLab.org / GitLab FOSS · GitLab

The 17.0 major release is coming on May 16, 2024! This version brings many exciting improvements to GitLab, but also removes some deprecated features. We are introducing three breaking change windows during which we expect breaking changes to be deployed to GitLab.com. You can read more about it on our blogpost . The first breaking change window begins 2024-04-22 09:00UTC and ends 2024-04-24 22:00UTC.

Yorick Peterse requested to merge finding-issues-by-labels-performance into master Nov 11, 2015

The changes in this MR ultimately lead to finding issues with(out) labels being about 2x faster due to:

Newly added indexes on issues.state and projects.visibility_level
Adjusting the query so that finding issues for multiple projects is more efficient