Re: sequential scan on child partition tables

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: sequential scan on child partition tables
Дата
Msg-id dcc563d10910172208g21b751b3p626c5a55b75f960a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: sequential scan on child partition tables  (Anj Adu <fotographs@gmail.com>)
Список pgsql-performance
On Thu, Oct 15, 2009 at 2:51 PM, Anj Adu <fotographs@gmail.com> wrote:
> This appears to be a bug in the optimizer with resepct to planning
> queries involving child partitions. It is clear that "any" index is
> being ignored even if the selectivity is high. I had to re-write the
> same query by explicitly "union-all" ' ing  the queries for individual
> partitions.

So, did adjusting cost parameters help at all?

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

Предыдущее
От: Melton Low
Дата:
Сообщение: Re: table full scan or index full scan?
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: Issues with \copy from file