Re: CTE materializing sets? - Mailing list pgsql-general

From Craig Ringer
Subject Re: CTE materializing sets?
Date
Msg-id 5073F810.5060703@ringerc.id.au
Whole thread Raw
In response to Re: CTE materializing sets?  (Serge Fonville <serge.fonville@gmail.com>)
List pgsql-general
On 10/09/2012 05:53 PM, Serge Fonville wrote:
> This indeed is a very interesting question.
>
> At http://wiki.postgresql.org/wiki/CTEReadme it seems to suggest that a
> CTE is just rewritten and the resulting query is executed.

CTEs are an optimisation fence, so there's something more than a simple
rewrite.

--
Craig Ringer



pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: CTE materializing sets?
Next
From: Виктор Егоров
Date:
Subject: Re: CTE materializing sets?