Re: How to get around LIKE inefficiencies?

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 <pjw@rhyme.com.au> 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 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