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

From Andrew Dunstan
Subject Re: Poor performance using CTE
Date
Msg-id 50AD2E88.4000902@dunslane.net
Whole thread Raw
In response to Re: Poor performance using CTE  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Poor performance using CTE  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-performance
On 11/21/2012 02:30 PM, Gavin Flower wrote:
> WITH FENCE foo AS (SELECT ...)
> default?
>
>
> WITHOUT FENCE foo AS (SELECT ...)     :-)
> Nah!
> I prefer this, but it is too specific to 'WITH',
> and very unSQL standardish!
>
> Alternatively one of the following
>
>  1. WITH UNFENCED foo AS (SELECT ...)
>  2. WITH NO FENCE foo AS (SELECT ...)
>  3. WITH NOT FENCE foo AS (SELECT ...)
>
> I loke the firsat variant, but the 3rd is
> most SQL standardish!
>

As Tom (I think) pointed out, we should not have a syntax tied to CTEs.

cheers

andrew



pgsql-performance by date:

Previous
From: Willem Leenen
Date:
Subject: Re: Hints - experiences from other rdbms
Next
From: Craig Ringer
Date:
Subject: Re: Poor performance using CTE