Re: Huge speed penalty using <>TRUE instead of =FALSE

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