I found using recursive CTEs incredibly slow for assembling tree data from a normalized representation. It would make getting the results of a query at least d

I found using recursive CTEs incredibly slow for assembling tree data from a normalized representation. It would make getting the results of a query at least d times slower for assembling the path of nodes d deep in the hierarchy. The upside was cheap tree edit operations but those were a lot less frequent than reads.