Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge speed penalty using <>TRUE instead of =FALSE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Huge speed penalty using <>TRUE instead of =FALSE
Date
Msg-id 29115.1247839909@sss.pgh.pa.us
Whole thread Raw
In response to Huge speed penalty using <>TRUE instead of =FALSE  (Jan-Ivar Mellingen <jan-ivar.mellingen@alreg.no>)
List pgsql-bugs
Tree view 
Jan-Ivar Mellingen <jan-ivar.mellingen@alreg.no> writes:
> One of our customers discovered that by replacing <>TRUE with =FALSE in
> a query of a table containing 750.000 records reduced the query time
> from about 12 seconds to about 60 milliseconds!

This is not a bug.  The set of operators that are indexable is well
documented, and <> is not one of them.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Huge speed penalty using <>TRUE instead of =FALSE
Next
From: Tom Lane
Date:
Subject: Re: Huge speed penalty using <>TRUE instead of =FALSE