7 ms·
I think the change introduced this syntax with history as materialized { .. } so you have to declare the CTE as materialized to get this optimization
by systems 6y ago
I think the change introduced this syntax
with history as materialized { .. }
so you have to declare the CTE as materialized to get this optimization
- simonw 6y agoThat's not how I interpret the release notes, but I can see why they are being misunderstood like that (assuming I'm right in my interpretation).
- masklinn 6y ago> so you have to declare the CTE as materialized to get this optimization Not necessarily. You can get a materialized CTE if you request it regardless of its usage pattern, but you will also get one if the CTE is used more than once unless you suppress it.