Postgres Pro
Downloads
Home   >   mailing lists

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

From Claudio Freire
Subject Re: Poor performance using CTE
Date
Msg-id CAGTBQpZ_Za-XSXvmPUx3F7wgeX=HB1xUpDsn+1DXY3a87YJLBQ@mail.gmail.com
Whole thread Raw
In response to Re: Poor performance using CTE  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Poor performance using CTE
List pgsql-performance
Tree view 
On Tue, Nov 20, 2012 at 12:04 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> The problem here is very clear.  Oracle is optimizing through the CTE.
>  PostgreSQL does not do this by design -- CTE's are used as a forced
> materialization step.

While I love that design (it lets me solve lots of problems for huge
queries), wouldn't pushing constraints into the CTE be a rather safe
optimization?

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Poor performance using CTE
Next
From: Merlin Moncure
Date:
Subject: Re: Poor performance using CTE