Andy Fan <zhihui(dot)fan1213(at)gmail(dot)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