2011/1/16 pasman pasmaÅski <pasman.p@xxxxxxxxx>: > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
