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

From Andrea Arcangeli
Subject Re: NOT LIKE much faster than LIKE?
Date
Msg-id 20060111091841.GA15897@opteron.random
Whole thread Raw
In response to Re: NOT LIKE much faster than LIKE?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
On Wed, Jan 11, 2006 at 09:07:45AM +0000, Simon Riggs wrote:
> I would suggest we do this only when all of these are true
> - when accessing more than one table, so the selectivity could effect a
> join result

FWIW my problem only happens if I join: on the main table where the
kernel_version string is stored (without joins), everything is always
blazing fast. So this requirement certainly sounds fine to me.

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: NOT LIKE much faster than LIKE?
Next
From: Alessandro Baretta
Date:
Subject: Re: 500x speed-down: Wrong statistics!