Re: join and query planner

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: join and query planner
Дата
Msg-id 20050712143552.GA32711@wolff.to
обсуждение исходный текст
Ответ на join and query planner  ("Dario Pudlo" <dariop@unitech.com.ar>)
Список pgsql-performance
On Wed, Jul 06, 2005 at 18:54:02 -0300,
  Dario Pudlo <dariop@unitech.com.ar> wrote:
> (first at all, sorry for my english)
> Hi.
>    - Does "left join" restrict the order in which the planner must join
> tables? I've read about join, but i'm not sure about left join...

The left join operator is not associative so in general the planner doesn't
have much flexibility to reorder left (or right) joins.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: cost-based vacuum
Следующее
От: Yves Vindevogel
Дата:
Сообщение: Projecting currentdb to more users