Skip to content

Threat Insights - Drop unused vuln-reads indices

Gregory Havenga requested to merge 456959-threat-insights-drop-unused-indices into master

What does this MR do and why?

Indices index_project_vulnerability_reads_common_finder_query_desc and index_group_vulnerability_reads_common_finder_query_desc have been identified as redundant indices on the vulnerability_reads table. In order to complete rollout of the new Vulnerability Group Report optimisations, we need new indices, but due to the high 26 indices on the table already, we need to provide breathing room by removing the indices first.

This MR removes both.

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.

Related to #456959 (closed)

Merge request reports