Re: Copy path in Dynamic programming - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Copy path in Dynamic programming
Date
Msg-id 13343.1280262296@sss.pgh.pa.us
Whole thread Raw
In response to Re: Copy path in Dynamic programming  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Jul 22, 2010 at 12:38 PM, vamsi krishna
> <vamsikrishna1902@gmail.com> wrote:
>> if lev=5 , and let's say there are two combinations setA = {1,2,3,4,5} and
>> set B={6,7,8,9,10}.
>> 
>> I want to reuse the plan of {1.2,3,4,5} for {6,7,8,9,10}.

> I don't think that makes any sense.

Yeah.  The theoretical problem is that substituting setB for setA could
change the estimated rowcounts, and thus you should not use the same
path.  The practical problem is that the Path datastructure doesn't
store the specific quals to be used, in general --- it relies on the
RelOptInfo structures to remember which quals need to be checked during
a scan.  So you can't just "copy the path and substitute some other
qual".  You could maybe do it if you copied the entire planner
workspace, but that's not too practical from a memory consumption
standpoint.  Not to mention that a lot of the node types in question
don't have copyfuncs.c support, which is only partly laziness --- it's
also the case that copyObject() is incapable of coping with circular
linkages, and the planner data structures are full of those.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: do we need to postpone beta4?
Next
From: Robert Haas
Date:
Subject: Re: do we need to postpone beta4?