Re: Poor performance using CTE

[Jeremy Harris <jgh@xxxxxxxxxxx>]

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 ... ;

--
Jeremy




--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance