Re: [SQL] quest:optimization with indexes

Tom Lane wrote:

> Clayton Cottingham <drfrog(at)smartt(dot)com> writes:
> > thanks for all those 'like' tips i was wonderinng, would using regex be the
> > same as far as the indexing rules go?
>
> It's equivalent --- an index can help if the pattern is anchored to the
> start of the string. Of course the pattern notation is different...
>
> regards, tom lane

what about helper software like glimpse, as per my other thread?

i was told to use glimpse, because full text index {fti} isnt robust enough to
handle large db's

what do you think the most optimized way of handling this sort of thing would
be?