Skip to content

Cleanup unused index and fk for ci_build_trace_metadata

Max Orefice requested to merge morefice/cleanup-fk-ci-job-artifacts-2 into master

Ref: #435802 (closed)

What does this MR do and why?

Following up !141474 (merged)

This MR does 2 things in order to prepare ci_job_artifacts to be partitioned:

Why are we doing this?

Mandatory steps in order to partition a table as explained in our documentation.

Database

Looks like we can remove those indexes are they are not being used anymore 👇

Old index New index
index_ci_build_trace_metadata_on_trace_artifact_id index_ci_build_trace_metadata_on_trace_artifact_id_partition_id

Merge request reports

Loading