Skip to content

Prepare async index for system_note_metadata

euko requested to merge 407289-create-async-index-for-system-note-metadata into master

What does this MR do and why?

resource_link_events table needs to be backfilled based on the data from system_note_metadata and notes.

This MR prepares the async addition of a DB index to facilitate the backfilling which will be done via batched background migration.

The index targets the table system_note_metadata. A synchronous creation takes more or less an hour.

MR acceptance checklist

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

Related to #407289 (closed)

Edited by euko

Merge request reports