On Thu, Aug 27, 2020 at 8:05 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > Andy Fan <zhihui.fan1...@gmail.com> writes: > > I do see the README says we support bushy plans and I also see bushy > > plans in real life (for example tpc-h Q20) like below. However I don't > know > > how it is generated with the algorithm in join_search_one_lev since it > > always > > make_rels_by_clause_join with joinrel[1] which is initial_rels which is > > baserel. > > Hmm? Bushy plans are created by the second loop in join_search_one_level, > starting about line 150 in joinrels.c. > > regards, tom lane >
Yes.. I missed the second loop:(:(:( -- Best Regards Andy Fan
