Re: Removing INNER JOINs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Removing INNER JOINs
Дата
Msg-id 20586.1417630304@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Removing INNER JOINs  (Atri Sharma <atri.jiit@gmail.com>)
Список pgsql-hackers
Atri Sharma <atri.jiit@gmail.com> writes:
> Does it also make sense to recalculate the costs from scratch for the
> replan? It might be, I am just asking.

The join costs would be recalculated from scratch, yes.  The
single-relation Paths would already exist and their costs would not
change.  Again, if you've not studied how GEQO works, you probably
should go do that before thinking more about how this would work.
        regards, tom lane



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: tracking commit timestamps
Следующее
От: Atri Sharma
Дата:
Сообщение: Re: Removing INNER JOINs