Re: How is bushy plans generated in join_search_one_lev

2020-08-26 Thread Andy Fan
On Thu, Aug 27, 2020 at 8:05 AM Tom Lane wrote: > Andy Fan 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

Re: How is bushy plans generated in join_search_one_lev

2020-08-26 Thread Tom Lane
Andy Fan 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 i