Horton

Re: How to get around LIKE inefficiencies?

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: The Hermit Hacker <scrappy@hub.org>, pgsql-hackers@postgresql.org
Date: 2000-11-06T02:36:32Z
Lists: pgsql-hackers 
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, Pennsylvania 19026