Investigate what other tables need to be vertically sharded to allow vertical sharding of ci_builds
As part of &5883 (closed) we want to look into what it takes to vertically shard the ci_builds
table.
In this issue we should look into what other tables we may need to shard if we want to vertically shard ci_builds
. There is some overlap with #331412 (closed), but that issue mostly focuses on the constraints side of things. There may be other tables we'd want to move into this CI database, such as tables related to CI even though we don't necessarily join these tables or have foreign keys pointing to them.
The knowledge of this likely already exists as a form of tribal knowledge to some extend, but we should use this issue to clearly write it down; allowing us to more easily refer to it later.
Confidence level: 80%
Edited by Yorick Peterse