Re: How to get around LIKE inefficiencies? - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: How to get around LIKE inefficiencies?
Date
Msg-id Pine.BSF.4.21.0011052311340.928-100000@thelab.hub.org
Whole thread Raw
In response to Re: How to get around LIKE inefficiencies?  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: How to get around LIKE inefficiencies?
Re: How to get around LIKE inefficiencies?
List pgsql-hackers
On Mon, 6 Nov 2000, Philip Warner wrote:

> At 21:59 5/11/00 -0500, Tom Lane wrote:
> >
> >Looks like a great kluge to me ;-)
> >
> 
> Hmph. I prefer to think of it as a 'user-defined optimizer hint'. ;-}

Except, if we are telling it to get rid of using the index, may as well
get rid of it altogether, as updates/inserts would be slowed down by
having to update that too ...

i can now do 3 word searches in what looks like no time ... not sure how
it will look after I have ~100k documents indexed, but at least now its
not diead at 22k ...





pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: How to get around LIKE inefficiencies?
Next
From: Tom Lane
Date:
Subject: Re: How to get around LIKE inefficiencies?