Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1 - Mailing list pgsql-hackers

From Qi Huang
Subject Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1
Date
Msg-id BAY159-W3281E933B360B8221D8279A3E70@phx.gbl
Whole thread Raw
Responses Re: Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi, hackers
    I modified the code in add_path() a bit so that all the query path candidates inside pathlist will not be removed and all new path will be added into the pathlist, thus all path candidates are kept in pathlist. I then tested a four-relation query. In 9.1.3, I can see thousands of candidates in the final RelOptInfo, and some of them are even busy trees. But in 9.2 beta1 which I forked from github, there are no such busy trees and only about 50 join path in total, which should match the requirement of System R algo. Is there any modification regarding the system R algo in the new release? And something wrong in algo in 9.1.3?
    Thanks
   

Best Regards
Huang Qi Victor
Computer Science of National University of Singapore

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Posix Shared Mem patch
Next
From: "Etsuro Fujita"
Date:
Subject: Re: [PATCH] Lazy hashaggregate when no aggregation is needed