Re: Common Table Expressions (WITH RECURSIVE) patch - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Common Table Expressions (WITH RECURSIVE) patch
Date
Msg-id F82A9EDF-70BA-452A-B52B-4C9FC5527808@enterprisedb.com
Whole thread Raw
In response to Re: Common Table Expressions (WITH RECURSIVE) patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Common Table Expressions (WITH RECURSIVE) patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Common Table Expressions (WITH RECURSIVE) patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

greg

On 24 Sep 2008, at 02:45, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The next big
> thing seems to be to figure out exactly how to do multiple references
> to CTE outputs, so that we can de-bogotify the planner.

I've looked and don't seem to still have the source tree where I  
worked on this. I remember how I made the changes to tuplestore which  
was mostly mechanical. The trick I think will be in adding a special  
purpose executor method which passes the call site to the node below.  
This depends on the observation that if we always memoize results then  
each call site can only have one active call. That is, we don't need  
to maintain a full stack tree.   


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: 0x1A in control file on Windows
Next
From: Simon Riggs
Date:
Subject: Re: parallel pg_restore