Re: Date index not used when selecting a date range

Поиск
Список
Период
Сортировка
От Poul Møller Hansen
Тема Re: Date index not used when selecting a date range
Дата
Msg-id 488EC5D6.9090707@pbnet.dk
обсуждение исходный текст
Ответ на Date index not used when selecting a date range  (Poul Møller Hansen <freebsd@pbnet.dk>)
Ответы Re: Date index not used when selecting a date range  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
>> This is the index:
>> CREATE INDEX idx_stat_date_node_type
>>  ON public.stat
>>  USING btree
>>  (date, node, "type");
>>
>>
>> explain SELECT * FROM public.stat WHERE node = '1010101010' AND
>> ("date" <= '2008-06-30'::date AND "date" >= '2008-01-01'::date)
>>
>
> Try changing the index order to node, date rather than date, node. You
> need the column on which you'll be doing range checking to be the
> furthest to the right in the index column list.
>
>
Then it works. Unfortunately the production database is always in use
and it contains more than 100 mill. rows,
so creating an index is not an option.

Poul



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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: How to give input a file for a stored procedure
Следующее
От: Poul Møller Hansen
Дата:
Сообщение: Re: Date index not used when selecting a date range