[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Index order ignored after `is null` in query
From:       Jim Nasby <Jim.Nasby () BlueTreble ! com>
Date:       2014-11-15 2:12:32
Message-ID: 5466B690.5000705 () BlueTreble ! com
[Download RAW message or body]

On 11/7/14, 5:14 AM, Artūras Lapinskas wrote:
> thanks for your time and answer. Not treating IS NULL as equality operator \
> definitely helps me to make more sense out of previous explains.

You can also try creating a partial index WHERE b IS NULL. WHERE b IS NOT NULL can \
                also sometimes be useful, though for different reasons.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[prev in list] [next in list] [prev in thread] [next in thread]