Craig Ringer <craig.ringer@2ndquadrant.com> writes: > - as you noted, it is hard to decide when it's worth inlining vs > materializing for CTE terms referenced more than once.
There's already a pretty large hill to climb here in the way of breaking peoples' expectations about CTEs being optimization fences. Breaking the documented semantics about CTEs being single-evaluation seems to me to be an absolute non-starter.
why we cannot to introduce GUC option - enable_cteoptfence ?