Re: Indexes on NULL's and order by ... limit N queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Indexes on NULL's and order by ... limit N queries
Дата
Msg-id 3032.1228137764@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Indexes on NULL's and order by ... limit N queries  (Maxim Boguk <mboguk@masterhost.ru>)
Ответы Re: Indexes on NULL's and order by ... limit N queries  (Maxim Boguk <mboguk@masterhost.ru>)
Список pgsql-general
Maxim Boguk <mboguk@masterhost.ru> writes:
> Looks like when indexed search over NULL's added, planner wasn't learned right way use such index on  "where
somethingis NULL order by ... limit ..."  
> queries.

There's nothing wrong with the plan; you've just got too many NULLs to
make it worth using the index for that.

            regards, tom lane

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

Предыдущее
От: Siddharth Shah
Дата:
Сообщение: Re: configure options
Следующее
От: elekis
Дата:
Сообщение: Re: Cannot open include file: 'nodes/nodes.h'