Remove temporary indexes for partitioning CI tables
Problem
In #387301 (closed) we added a lot of temporary indexes in order to clean up invalid data on gitlab.com
Once all data will be fixed we will longer need those temporary indexes.
Solution
- Remove all temporary indexes
table name | temporary index name | cleanup MR | index removed |
---|---|---|---|
ci_build_needs |
tmp_index_ci_build_needs_on_partition_id_and_id |
!113507 (merged) | |
ci_build_report_results |
tmp_index_ci_build_report_results_on_partition_id_and_build_id |
!113507 (merged) | |
ci_build_trace_metadata |
tmp_index_ci_build_trace_metadata_on_partition_id_and_id |
!113507 (merged) | |
ci_builds |
tmp_index_ci_builds_on_partition_id_and_id |
!113507 (merged) | |
ci_job_artifacts |
tmp_index_ci_job_artifacts_on_partition_id_and_id |
!113507 (merged) | |
ci_job_variables |
tmp_index_ci_job_variables_on_partition_id_and_id |
!113507 (merged) | |
ci_pipeline_variables |
tmp_index_ci_pipeline_variables_on_partition_id_and_id |
!113507 (merged) | |
ci_pipelines |
tmp_index_ci_pipelines_on_partition_id_and_id |
!113507 (merged) | |
ci_sources_pipelines |
tmp_index_ci_sources_pipelines_on_partition_id_and_id & tmp_index_ci_sources_pipelines_on_partition_id_and_id
|
!113507 (merged) | |
ci_stages |
tmp_index_ci_stages_on_partition_id_and_id |
!113507 (merged) | |
ci_running_builds |
tmp_index_ci_running_builds_on_partition_id_and_id |
!113507 (merged) | |
ci_pending_builds |
tmp_index_ci_pending_builds_on_partition_id_and_id |
!113507 (merged) | |
ci_builds_runner_session |
tmp_index_ci_builds_runner_session_on_partition_id_and_id |
!113507 (merged) |
Edited by Marius Bobin