Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexes on NULL's and order by ... limit N queries - Mailing list pgsql-general

From Tom Lane
Subject Re: Indexes on NULL's and order by ... limit N queries
Date
Msg-id 3032.1228137764@sss.pgh.pa.us
Whole thread Raw
In response to Indexes on NULL's and order by ... limit N queries  (Maxim Boguk <mboguk@masterhost.ru>)
Responses Re: Indexes on NULL's and order by ... limit N queries  (Maxim Boguk <mboguk@masterhost.ru>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Siddharth Shah
Date:
Subject: Re: configure options
Next
From: elekis
Date:
Subject: Re: Cannot open include file: 'nodes/nodes.h'