[go: up one dir, main page]
Skip to content

Backfill group archive state to Vulnerability rows

Ryan Wellsrequested to merge
572475/postgres-backfill-for-vuln-reads-and-statistics into master

What does this MR do and why?

Backfill group archive state to Vulnerability rows

This migration backfills the Group archived state to Vulnerability Reads and Vulnerability Statistics.

To better utilise existing indexes, the migration works as follows:

  1. Batch by NamespaceSettings, filtering by archived = true. Internal query performance link.
  2. Find the Namespace by looking up by ID (primary key lookup, no plan needed).

We start iterating the NamespaceSettings to find archived groups, and for each of those namespaces use the TraversalIDs to iterate over Vulnerability Reads / Statistics, archiving records as appropriate.

MR acceptance checklist

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

Edited by Ryan Wells

Merge request reports