Cleanup unused index and fk for ci_build_trace_metadata
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:
- Drop one index longer being used (see thanos queries below) for self-managed (already removed from gitlab.com)
- Remove one FK which was updated to include
partition_idin !138898 (merged)
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 |