Re: Join Removal/ Vertical Partitioning

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Join Removal/ Vertical Partitioning
Дата
Msg-id 12000.1214603444@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Join Removal/ Vertical Partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Join Removal/ Vertical Partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Thu, 2008-06-26 at 13:42 -0400, Tom Lane wrote:
>> It might be possible to treat "ignore the RHS" as a join strategy and
>> try to apply it while forming join relations, which would be late enough
>> to have all the needed info available.

> Oh, actually have a join node that is a no-op, with a path cost of zero?

Not even that: just return the best path(s) for the LHS as the paths for
the joinrel.
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: gsoc, text search selectivity and dllist enhancments
Следующее
От: Jean-Michel Pouré
Дата:
Сообщение: XML index support