Re: query against single partition uses index, against master table does seq scan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: query against single partition uses index, against master table does seq scan
Дата
Msg-id 24073.1474510287@sss.pgh.pa.us
обсуждение исходный текст
Ответ на query against single partition uses index, against master table does seq scan  (Mike Broers <mbroers@gmail.com>)
Ответы Re: query against single partition uses index, against master table does seq scan
Список pgsql-performance
Дерево обсуждения 
Mike Broers <mbroers@gmail.com> writes:
> Hello, I am curious about the performance of queries against a master table
> that seem to do seq scans on each child table.  When the same query is
> issued at a partition directly it uses the partition index and is very
> fast.

What PG version is that?  For me, everything since 9.0 seems to be willing
to consider the type of plan you're expecting.

            regards, tom lane

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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
Следующее
От: Mike Broers
Дата:
Сообщение: Re: query against single partition uses index, against master table does seq scan