Set slice limit when triggering events related to the creation of vulnerability occurrences

What does this MR do and why?

Set slice limit when triggering events related to the creation of vulnerability occurrences.

This will reduce the load as per the following queries:

Before After
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/34996/commands/108438 https://console.postgres.ai/gitlab/gitlab-production-main/sessions/35620/commands/110292

This change was suggested by @a_akgun in this thread.

References

Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.

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.

Edited by Zamir Martins

Merge request reports

Loading