Re: How is bushy plans generated in join_search_one_lev

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How is bushy plans generated in join_search_one_lev
Дата
Msg-id 2987895.1598486704@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How is bushy plans generated in join_search_one_lev  (Andy Fan <zhihui.fan1213@gmail.com>)
Ответы Re: How is bushy plans generated in join_search_one_lev  (Andy Fan <zhihui.fan1213@gmail.com>)
Список pgsql-hackers
Andy Fan <zhihui.fan1213@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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY
Следующее
От: Andy Fan
Дата:
Сообщение: Re: How is bushy plans generated in join_search_one_lev