Try to benchmark your CTE query against a nested-sets implementation as described e.g. here: http://www.evanpetersen.com/item/nested-sets.html http://www.evanp

Try to benchmark your CTE query against a nested-sets implementation as described e.g. here: http://www.evanpetersen.com/item/nested-sets.html http://www.evanpetersen.com/item/nested-sets.html