diff options
| author | Thong Kuah <tkuah@gitlab.com> | 2019-07-08 09:03:09 +0300 |
|---|---|---|
| committer | James Lopez <james@gitlab.com> | 2019-07-08 09:03:09 +0300 |
| commit | 3bc76511a066626c06d3d3b76d78e928770c46e0 (patch) | |
| tree | b38a3712d31a3b74ce73eaefa71e8fb73d1e5718 /changelogs/unreleased | |
| parent | 299387e311d30c50b060bc62141b4ff6b2cfefe8 (diff) | |
Create CTE query for clusters hierarchy
- This enables us to use a scope to query all clusters in group
hierarchy order in one query, and also enables us to union to instance
clusters later.
- Handle case where clusters not present at level. In which case the
query should go ahead and return the next level's clusters.
- Swap with new CTE query behind Feature flag. This FF is default
disabled.
Diffstat (limited to 'changelogs/unreleased')
| -rw-r--r-- | changelogs/unreleased/clusters-group-cte.yml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/changelogs/unreleased/clusters-group-cte.yml b/changelogs/unreleased/clusters-group-cte.yml new file mode 100644 index 00000000000..4b51249062d --- /dev/null +++ b/changelogs/unreleased/clusters-group-cte.yml @@ -0,0 +1,5 @@ +--- +title: Use CTE to fetch clusters hierarchy in single query +merge_request: 30063 +author: +type: performance |