Re: How to get around LIKE inefficiencies?

Sorry to be getting in here late.  Have you tried CLUSTER?  If it is
using an index scan, and it is slow, cluster often helps, especially
when there are several duplicate matches, as there is with LIKE.  Let me
know how that works.

> A brute-force answer would be to remove the url_url index ;-)
> dunno if that would slow down other queries, however.
> 
>             regards, tom lane
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026