3 ms·
Yeah, there was a lengthy discussion about what the default behavior should be during development. Ultimately, inline by default prevailed, and I think it was t
by pgaddict 7y ago
Yeah, there was a lengthy discussion about what the default behavior should be during development. Ultimately, inline by default prevailed, and I think it was the right decision.
Inlining seems like the right choice for vast majority of cases, but yeah - there are cases where enforcing materialization is a win.
Once you try this on your application, it'd be interesting to share some stats about the queries / CTEs that benefited from materialization. That might be quite useful for improving the "materialize vs. inline" logic in future releases.
- ohlookabird 7y agoThat's a good suggestion. I try to gather some numbers and post to the mailing list.