Skip to content

Monitor linear queries for project authorization

Aboobacker MK requested to merge tachyons_linear_query_rollout into master

What does this MR do and why?

We previously added a linear query to replace the recursive CTE for project authorizations queries via !117988 (merged) But before we roll our the more performant query, we need to be certain that both versions of the query return the same results. Comparing the results for a subset of users behind a separate feature flag was suggested in the original MR: !117988 (comment 1384889602) This MR aims to do just that: behind the compare_project_authorization_linear_cte feature flag, which we will roll out to no more than 10% of users, we will compare the results of each query and log whether they match or not.

Performance is measured by worker duration. feature flag linear_project_authorization is to sent to compare the average worker execution with and without linear queries.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

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

Related to #398261 (closed)

Edited by Aboobacker MK

Merge request reports