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