Re: Left joins and inheritance (table partitioning)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Left joins and inheritance (table partitioning)
Дата
Msg-id 23675.1144209012@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Left joins and inheritance (table partitioning)  (Rod Taylor <pg@rbt.ca>)
Ответы Re: Left joins and inheritance (table partitioning)  (Rod Taylor <pg@rbt.ca>)
Список pgsql-hackers
Rod Taylor <pg@rbt.ca> writes:
> I've recently been playing with table partitioning limitations. Turning
> over a large volume of data in inherited structures in a live
> environment, and have run into a couple of snags in the planner.

> The first is that LEFT JOIN will always do a sequential scan on all
> inherited tables.

Try it in CVS HEAD.
        regards, tom lane


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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Left joins and inheritance (table partitioning)
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: Left joins and inheritance (table partitioning)