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

From Jeremy Harris
Subject Re: Poor performance using CTE
Date
Msg-id 50AE2BC9.7040207@wizmail.org
Whole thread Raw
In response to Re: Poor performance using CTE  (Craig Ringer <craig@2ndQuadrant.com>)
Responses Re: Poor performance using CTE
List pgsql-performance
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




pgsql-performance by date:

Previous
From: Niklas Paulsson
Date:
Subject: SQL performance question
Next
From: Jon Nelson
Date:
Subject: Re: Poor performance using CTE