Re: allowing extensions to control planner behavior

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: allowing extensions to control planner behavior
Дата
Msg-id 3131957.1724789735@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: allowing extensions to control planner behavior  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: allowing extensions to control planner behavior
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I believe the minimum viable product here
> is probably something like:

> - control over scan methods
> - control over index selection
> - control over join methods
> - control over join order

Seems reasonable.  It might be possible to say that our answer
to "control over join order" is to provide a hook that can modify
the "joinlist" before it's passed to make_one_rel.  If you want
to force a particular join order you can rearrange that
list-of-lists-of-range-table-indexes to do so.  The thing this
would not give you is control over which rel is picked as outer
in any given join step.  Not sure how critical that bit is.

            regards, tom lane



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