Re: Poor performance using CTE

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance using CTE
Date: 2012-11-22 13:42:33
Message-ID: 50AE2BC9.7040207@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2012-11-22 14:23:57 Re: Poor performance using CTE
Previous Message Niklas Paulsson 2012-11-22 12:06:01 SQL performance question