Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: How to get around LIKE inefficiencies?
Date
Msg-id 1475.973477684@sss.pgh.pa.us
Whole thread Raw
In response to How to get around LIKE inefficiencies?  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: How to get around LIKE inefficiencies?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: How to get around LIKE inefficiencies?  (Philip Warner <pjw@rhyme.com.au>)
Re: How to get around LIKE inefficiencies?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
Tree view 
A brute-force answer would be to remove the url_url index ;-)
dunno if that would slow down other queries, however.
        regards, tom lane

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: How to get around LIKE inefficiencies?
Next
From: Bruce Momjian
Date:
Subject: Re: How to get around LIKE inefficiencies?