Re: sequential scan on child partition tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: sequential scan on child partition tables
Дата
Msg-id 22237.1255583724@sss.pgh.pa.us
обсуждение исходный текст
Ответ на sequential scan on child partition tables  (Anj Adu <fotographs@gmail.com>)
Ответы Re: sequential scan on child partition tables  (Anj Adu <fotographs@gmail.com>)
Список pgsql-performance
Anj Adu <fotographs@gmail.com> writes:
> This query is doing a sequential scan on the child partitions even
> though indexes on all constrained columns are present

It looks to me like it's doing exactly what it is supposed to, ie,
indexscan on the partitions where it would help and seqscans on the
partitions where it wouldn't.  Indexscan is not better than seqscan
for retrieving all or most of a table.

            regards, tom lane

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

Предыдущее
От: Anj Adu
Дата:
Сообщение: sequential scan on child partition tables
Следующее
От: Glyn Astill
Дата:
Сообщение: [OT] Recommended whitebox server vendors in the UK?