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(at)rhyme(dot)com(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026