On Thu, Nov 22, 2012 at 7:42 AM, Jeremy Harris <jgh@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
