Re: Adding an "and is not null" on an indexed field slows the query down immensely.

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Adding an "and is not null" on an indexed field slows the query down immensely.
Дата
Msg-id AANLkTik+HPHC3umeBrTA9VjhVCAv24Q=36Hc7B1zr423@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Adding an "and is not null" on an indexed field slows the query down immensely.  (pasman pasmański <pasman.p@gmail.com>)
Список pgsql-general
Дерево обсуждения 
2011/1/16 pasman pasmański <pasman.p@gmail.com>:
> I think this is a planner's bug. Can you send these explains to pgsql-bugs ?
>



Sure. BTW I thought I would change the query a little by putting a AND
index_value .>100 instead of index_delta and it didn't help at all. I
thought maybe using another index would help but it didn't.

So what I did was add NULLS LAST which was more bearable.

This really should be a pretty quick query, there are only twenty
records after all and all criteria fields are indexed.

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

Предыдущее
От: pasman pasmański
Дата:
Сообщение: Re: Adding an "and is not null" on an indexed field slows the query down immensely.
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Install PostgreSQL as part of a desktop application, but how to coop with existing installations?