Skip to content

WIP Use UNION ALL instead of UNION on the recursive query for nested namespaces

Gregory Stark requested to merge recursive-join-union-all into master

I noticed this code uses UNION where it seems UNION ALL would suffice since it seems to be including the primary key in the recursive result set and we don't have any loops in our nested groups (I hope!)

Database Checklist

When adding or modifying queries to improve performance:

  • Included data that shows the performance improvement, preferably in the form of a benchmark
  • Included the output of EXPLAIN (ANALYZE, BUFFERS) of the relevant queries

Merge request reports