Skip to content

Add partitioned index and FK for ci_job_artifacts and ci_builds

Marius Bobin requested to merge 382033-mb-update-ci_builds-ci_job_artifacts-fks into master

What does this MR do and why?

Related to #382033 (closed), it's another step to partition the ci_builds table.

It updates the foreign key between ci_job_artifacts and ci_builds to use the partitioning column.

Steps:

  1. Adding the partitioned index and FK: !110395 (merged)
  2. Fixing existing data: #387301 (closed)
  3. Validating and removing the old FK: !111166 (merged)

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

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

Related to #382033 (closed)

Edited by Marius Bobin

Merge request reports