Horton
Menu

Re: NOT LIKE much faster than LIKE?

andrea@cpushare.com

View thread
From: Andrea Arcangeli <andrea@cpushare.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Matteo Beccati <php@beccati.com>, pgsql-performance@postgresql.org
Date: 2006-01-11T09:18:41Z
Lists: 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.