Horton
Menu

Re: NOT LIKE much faster than LIKE?

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Andrea Arcangeli <andrea@cpushare.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-performance@postgresql.org
Date: 2006-01-10T02:29:05Z
Lists: pgsql-performance 
> 	UNLIKELY string LIKE '%% PREEMPT %%'
> 
> or:
> 
> 	LIKELY string NOT LIKE '%% PREEMPT %%'

You should be using contrib/tsearch2 for an un-anchored text search perhaps?