Skip to content

Sync Addition of indexes

In !166312 (merged) we added the two indexes asynchronously.

We need to add the indexes synchronously to complete the async index addition process outlined in the docs:

Cleanup replaced indexes

The indexes we added are copies of two existing indexes, with just the new has_vulnerability_resolution column appended. Therefore, we can also remove those now redundant indexes.

  • The redundant indexes
    • index_vulnerability_reads_common_attrs_and_detection_for_groups
    • index_vulnerability_reads_common_finder_query_2

Implementation Plan

  1. schedule migration to synchronously add the new indexes
  2. schedule migration to remove the redundant indexes
Edited by Michael Becker