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 CAM3SWZTUyxT6z1OJ_93WMz1gwr-VOjD4bYXxmrra5QY4JAHPaA@mail.gmail.com
Whole thread Raw
In response to Re: CTE optimization fence on the todo list?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, May 1, 2015 at 2:36 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Fri, May 1, 2015 at 4:53 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
>> ISTR a comment to the effect of the SQL standard effectively requires
>> current behavior.
>
> I'd be astonished.  The SQL standard doesn't even know that there is
> such a thing as an index, so I presume it doesn't dictate the behavior
> of the query planner either.

I agree. Somehow, the idea that this is within the standard caught on,
but I'm almost certain it's false.


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CTE optimization fence on the todo list?
Next
From: David Steele
Date:
Subject: Re: CTE optimization fence on the todo list?