Re: NOT LIKE much faster than LIKE?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Andrea Arcangeli <andrea@xxxxxxxxxxxx>
Subject: Re: NOT LIKE much faster than LIKE?
From: Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx>
Date: Tue, 10 Jan 2006 10:29:05 +0800
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <20060110022303.GA20168@xxxxxxxxxxxxxx>
References: <20060110014447.GB18474@xxxxxxxxxxxxxx> <24021.1136858688@xxxxxxxxxxxxx> <20060110022303.GA20168@xxxxxxxxxxxxxx>
User-agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)

	UNLIKELY string LIKE '%% PREEMPT %%'

or:

	LIKELY string NOT LIKE '%% PREEMPT %%'


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

Follow-Ups:
- Re: NOT LIKE much faster than LIKE?
  - From: Andrea Arcangeli

References:
- NOT LIKE much faster than LIKE?
  - From: Andrea Arcangeli
- Re: NOT LIKE much faster than LIKE?
  - From: Tom Lane
- Re: NOT LIKE much faster than LIKE?
  - From: Andrea Arcangeli

Prev by Date: Re: NOT LIKE much faster than LIKE?
Next by Date: Re: NOT LIKE much faster than LIKE?
Previous by thread: Re: NOT LIKE much faster than LIKE?
Next by thread: Re: NOT LIKE much faster than LIKE?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux