Re: How to get around LIKE inefficiencies?

On Sun, 5 Nov 2000, Tom Lane wrote:

> The Hermit Hacker <scrappy(at)hub(dot)org> writes:
> > 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 ...
>
> Sure --- but do you have any other query types where the index *is*
> useful? If so, Philip's idea will let you suppress use of the index
> for just this one kind of query.

Actually, it looks like they got a bit smart, and they search for the URL
in the url table based on the CRC32 value instead of text ...