Skip to content

Backfill related epic links to issue links

Felipe Cardozo requested to merge issue_454428 into master

What does this MR do and why?

Part of the migration of epics to work items(issues).

Introduces a background migration to backfill related epic links to issue links. The migration joins source and target epics for every related_epic_links record and backfills issue_links with the epics associated work item ids, link_type, and timestamps.

The plans of the query used to get values for the INSERT statement can be found at https://postgres.ai/console/gitlab/gitlab-production-main/sessions/28167/commands/87740. It used 1000 as batch size to cause additional stress, the actual migration should use batches of 100.

related to #454428 (closed)

When can we merge it?

After !152625 (merged) is merged

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Edited by Felipe Cardozo

Merge request reports