Skip to content

Disable ci_builds reindexing on Sundays

Marius Bobin requested to merge 386194-disable-ci-buildds-reindexing-on-sundays into master

What does this MR do and why?

Related to #386194 (closed)

Reindexing indexes from ci_builds can take up to 24 hours and if the reindex process starts late, it will span into Mondays and stop the autovacuum process on ci_pending_builds leading to slow job queues.

Old query: https://console.postgres.ai/gitlab/gitlab-production-ci/sessions/14067/commands/49129
New query on Sunday: https://console.postgres.ai/gitlab/gitlab-production-ci/sessions/14067/commands/49130

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.

Edited by Marius Bobin

Merge request reports