Postgres Pro
Downloads
Home   >   mailing lists

Re: CTE optimization fence on the todo list? - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: CTE optimization fence on the todo list?
Date
Msg-id CAM3SWZSiTAFAASOdPc02F+vZNtH=2CFKMiG53JpZUS-a9yxr6A@mail.gmail.com
Whole thread Raw
In response to Re: CTE optimization fence on the todo list?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: CTE optimization fence on the todo list?  (David Steele <david@pgmasters.net>)
List pgsql-hackers
Tree view 
On Fri, May 1, 2015 at 3:30 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Assuming that that sketch is accurate, it would take more code to provide
> a new user-visible knob to enable/disable the behavior than it would to
> implement the optimization, which makes me pretty much -1 on providing
> such a knob.  We should either do it or not.  If we do, people who want
> optimization fences should use the traditional "OFFSET 0" hack.

+1


-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CTE optimization fence on the todo list?
Next
From: Jim Nasby
Date:
Subject: Re: Reducing tuple overhead