Re: should we have a fast-path planning for OLTP starjoins?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: should we have a fast-path planning for OLTP starjoins?
Дата
Msg-id 3353330.1763222227@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: should we have a fast-path planning for OLTP starjoins?  (Nico Williams <nico@cryptonector.com>)
Список pgsql-hackers
Nico Williams <nico@cryptonector.com> writes:
> Some unsolicited advice:
> ...
> But here you can just use the order that the SQL uses.  It gives the
> author some power.

If that's the approach you want, it's been possible for decades:
"set join_collapse_limit = 1" and away you go.  I don't feel a
need to invent a different version of that for star schemas.

I do not think this patch should have ambitions beyond the stated
one of avoiding useless join-order search effort.  If you try to
load more than that onto the plate you'll probably end in failure.

            regards, tom lane



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