Select Git revision
sh-fix-npm-package-finder-all-projects.yml
Forked from
GitLab.org / GitLab
Source project has a limited visibility.
-
Stan Hu authored
In https://gitlab.com/gitlab-com/gl-infra/production/-/issues/3894, we found that query plans using `base_and_descendants` as a subquery in an `IN ()` clause may trigger a PostgreSQL v11 query planner bug, resulting in a significant performance degradation. https://gitlab.com/gitlab-org/gitlab/-/merge_requests/56078 works around this issue by moving the clause into a INNER JOIN, but finders may have to take advantage of this by calling `Group#all_projects` instead of `base_and_descendants`. This is a similar fix to https://gitlab.com/gitlab-org/gitlab/-/merge_requests/56346. Relates to https://gitlab.com/gitlab-org/gitlab/-/issues/324220
Stan Hu authoredIn https://gitlab.com/gitlab-com/gl-infra/production/-/issues/3894, we found that query plans using `base_and_descendants` as a subquery in an `IN ()` clause may trigger a PostgreSQL v11 query planner bug, resulting in a significant performance degradation. https://gitlab.com/gitlab-org/gitlab/-/merge_requests/56078 works around this issue by moving the clause into a INNER JOIN, but finders may have to take advantage of this by calling `Group#all_projects` instead of `base_and_descendants`. This is a similar fix to https://gitlab.com/gitlab-org/gitlab/-/merge_requests/56346. Relates to https://gitlab.com/gitlab-org/gitlab/-/issues/324220