Re: partitioning for speed, but query planner ignores

Поиск
Список
Период
Сортировка
От David Rysdam
Тема Re: partitioning for speed, but query planner ignores
Дата
Msg-id 87ioxfsu8e.fsf@loud.llan.ll.mit.edu
обсуждение исходный текст
Ответ на partitioning for speed, but query planner ignores  (David Rysdam <drysdam@ll.mit.edu>)
Список pgsql-general
On Wed, 2 Oct 2013 08:34:44 -0400, David Rysdam <drysdam@ll.mit.edu> wrote:
> However, when I run an explain or an explain analyze, I still seeing it
> checking both partitions. Is this because the query planner doesn't want
> to do a mod? Should I go with simple ranges, even though this adds a
> maintenance task?

I guess I should give some administrivia as well: Server is 9.2.1
running Linux. The configuration is otherwise pretty vanilla with only
minor, and poorly-understood, conf changes.

Вложения

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

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: Timestamp with and without timezone conversion confusion.
Следующее
От: Bill Moran
Дата:
Сообщение: Re: partitioning for speed, but query planner ignores