Jan-Ivar Mellingen <jan-ivar(dot)mellingen(at)alreg(dot)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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2009-07-17 14:21:43|
|Subject: Re: Huge speed penalty using <>TRUE instead of =FALSE |
|Previous:||From: Peter Eisentraut||Date: 2009-07-17 12:35:29|
|Subject: Re: Huge speed penalty using <>TRUE instead of =FALSE|