Skip to content

Schedule partial index for ci_build_report_results

Max Orefice requested to merge morefice/add-tmp-indexes-to-ci-build-report-results into master

Ref: #387301 (closed)

What does this MR do and why?

Following up !108823 (merged) where we referenced the wrong column when creating our index.

Our index was not created and we had to remove it from our async queue in !110494 (merged).

This MR re-schedules our temporary index to clean up efficiently invalid data in production.

Database

This is only required for gitlab.com as we executed !107472 (merged) only for saas. It will help to rebalance partition_id correctly in !108544 (closed).

It will not be a large percentage of the table, maybe 0.001 or even less. The indexes will cover the pipelines that were created in the incident window, before the application was restarted, which is around 5 hours.

MR acceptance checklist

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

Edited by Max Orefice

Merge request reports