Postgres Pro
Downloads
Home   >   mailing lists

Re: NOT LIKE much faster than LIKE? - Mailing list pgsql-performance

From Tom Lane
Subject Re: NOT LIKE much faster than LIKE?
Date
Msg-id 28232.1137014000@sss.pgh.pa.us
Whole thread Raw
In response to Re: NOT LIKE much faster than LIKE?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
Tree view 
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> On Wed, Jan 11, 2006 at 09:39:47PM +0100, Andrea Arcangeli wrote:
>> The index only helps the above query with = 0 and not the one with != 0,
>> but it seems not needed in practice.

> I suspect this is because of a lack of stats for functional indexes.

No, it's because != isn't an indexable operator.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: NOT LIKE much faster than LIKE?
Next
From: Bendik Rognlien Johansen
Date:
Subject: Re: Slow query with joins