Skip to content

Backport: Remove permissions JSONB column from the condition

Jarka Košanová requested to merge 498685-improve-cr-query-17-4 into 17-4-stable-ee

What does this MR do and why?

It removes the "permissions" condition (permissions is JSONB column) from the query used for getting custom roles per user/project (or group).

This has improved performance significantly as discussed here or here

  1. The root problem fixed (microbursts of CPU usage causing resource contention spikes)
  2. Overall general decreased CPU utilization.
  3. A substantial reduction in LWLock contention events.

MR acceptance checklist

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

  • This MR is backporting a bug fix, documentation update, or spec fix, previously merged in the default branch.
  • The MR that fixed the bug on the default branch has been deployed to GitLab.com (not applicable for documentation or spec changes).
  • This MR has a severity label assigned (if applicable).
  • Set the milestone of the merge request to match the target backport branch version.
  • This MR has been approved by a maintainer (only one approval is required).
  • Ensure the e2e:test-on-omnibus-ee job has either succeeded or been approved by a Software Engineer in Test.

Note to the merge request author and maintainer

If you have questions about the patch release process, please:

Edited by Jarka Košanová

Merge request reports

Loading