Re: Poor performance using CTE - Mailing list pgsql-performance

On Thu, Nov 22, 2012 at 7:42 AM, Jeremy Harris <jgh@wizmail.org> wrote:
> On 22/11/2012 00:08, Craig Ringer wrote:
>>
>> WITH
>>    FENCE foo AS (SELECT ...),
>>    bar AS (SELECT ...)
>> SELECT * FROM bar;
>>
>> Are we fencing just foo? Or all expressions?
>>
>
> WITH foo AS (FENCED SELECT ...),
>      bar AS (SELECT ...),
> SELECT ... ;

I would much rather see 'MATERIALIZE' instead of 'FENCED', unless the
by the latter you mean to forbid *all* optimizations, whereas with the
latter the meaning is pretty clear.

--
Jon