From 3bc76511a066626c06d3d3b76d78e928770c46e0 Mon Sep 17 00:00:00 2001 From: Thong Kuah Date: Mon, 8 Jul 2019 06:03:09 +0000 Subject: 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. --- changelogs/unreleased/clusters-group-cte.yml | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 changelogs/unreleased/clusters-group-cte.yml (limited to 'changelogs/unreleased/clusters-group-cte.yml') 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 -- cgit v1.2.3