Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject Re: NOT LIKE much faster than LIKE?
Date
Msg-id 43C31BF1.704@familyhealth.com.au
Whole thread Raw
In response to Re: NOT LIKE much faster than LIKE?  (Andrea Arcangeli <andrea@cpushare.com>)
Responses Re: NOT LIKE much faster than LIKE?  (Andrea Arcangeli <andrea@cpushare.com>)
List pgsql-performance
Tree view 
>     UNLIKELY string LIKE '%% PREEMPT %%'
>
> or:
>
>     LIKELY string NOT LIKE '%% PREEMPT %%'

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

pgsql-performance by date:

Previous
From: Andrea Arcangeli
Date:
Subject: Re: NOT LIKE much faster than LIKE?
Next
From: Andrea Arcangeli
Date:
Subject: Re: NOT LIKE much faster than LIKE?