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

From Peter Geoghegan
Subject Re: Poor performance using CTE
Date
Msg-id CAEYLb_WbXWZ6v4aDzNjrW71QNGe-gbvEW31zz++Yn9Csi2xo0Q@mail.gmail.com
Whole thread Raw
In response to Re: Poor performance using CTE  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-performance
On 21 November 2012 13:04, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
> Yes, I strongly feel that we should. Writing a query using WITH often makes
> it more readable. It would be a shame if people have to refrain from using
> it, because the planner treats it as an optimization fence.

+1

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services


pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Poor performance using CTE
Next
From: Shaun Thomas
Date:
Subject: Re: Hints (was Poor performance using CTE)