Re:

typea(at)l-i-e(dot)com kirjutas T, 03.12.2002 kell 01:45:
> Explains were posted previously, but I'll do a couple more.
>
> At its simplest, this takes 30 seconds:
>
> explain select article.* from article where lower(text) like '%einstein%';
> NOTICE: QUERY PLAN:
>
> Seq Scan on article (cost=0.00..1155.01 rows=1 width=216)

searches with LIKE use indexes only when the like expression starts
with a string (like 'einstein%') and even then only if in C locale.

You should check out some real full-text index add-ons, like contrib/tsearch or
construct your own using your imagination plus contrib/intarray and contrib/intagg :)

---------------
Hannu