Re: [HACKERS] How to get around LIKE inefficiencies?

[Bruce Momjian]

I am adding a new TODO item:

        * Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
          ANALYZE, and CLUSTER

Seems we should be able to emit NOTICE messages suggesting performance
improvements.



> Philip Warner <[EMAIL PROTECTED]> writes:
> > Could you trick it into not using the index (AND using the other strategy?)
> > by using a calculation:
> 
> >    AND ( (url.url || ' ') LIKE 'http://www.postgresql.org/% ');
> 
> > it's a bit nasty.
> 
> Looks like a great kluge to me ;-)
> 
>                       regards, tom lane
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026