Build an index for ci_builds that can completely replace the BuildNames model

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

The Problem

We created the Ci::BuildName model specifically so we could build an index on build names. The ci_builds table was not partitioned at the time and too large to successfully build a new index. This table now occupies about 1.1 TiB of disk space, and only half of that is the indexes.

(A) Proposal(s)

  1. When p_ci_builds has been reorganized into partitions of a manageable size, we should build the indexes we need for Build names on that table and completely drop the Ci::BuildName model from the application. It's just extra complexity we won't need.
  2. ???
Edited by 🤖 GitLab Bot 🤖