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
