Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding an "and is not null" on an indexed field slows the query down immensely. - Mailing list pgsql-general

From Tim Uckun
Subject Re: Adding an "and is not null" on an indexed field slows the query down immensely.
Date
Msg-id AANLkTik+HPHC3umeBrTA9VjhVCAv24Q=36Hc7B1zr423@mail.gmail.com
Whole thread Raw
In response to Re: Adding an "and is not null" on an indexed field slows the query down immensely.  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: pasman pasmański
Date:
Subject: Re: Adding an "and is not null" on an indexed field slows the query down immensely.
Next
From: Craig Ringer
Date:
Subject: Re: Install PostgreSQL as part of a desktop application, but how to coop with existing installations?