3 ms·
I never understood this. Why can't CTEs be transparently compiled into subqueries?
by nerdponx 9y ago
I never understood this. Why can't CTEs be transparently compiled into subqueries?
- dspillett 9y agoThere is plenty of discussion about it out there (search for "postgres cte optimisation fence") including official word. Note though that simply replacing CTE references with appropriate sub-queries simply won't work in the recursive case, and in some cases where a CTE is referred to multiple times the result may be an even less optimal query plan.
- deleted 9y ago[deleted]