Re: GiST index slower than seqscan

> In case you're unfamiliar with this particular horse, I'm using ltree to create
> a full text index on some <= 50 char long fields for a lookup table. The idea
> was to be able to tear through tons of data quickly finding case insensitive
> substring matches.
>

Why it is a ltree, not a tsearch?


>          Index Cond: (search_vector ~ '*.6.6.9.3.4.4.*'::lquery)

That's the problem. Queries which begin with '*' will be slow enough...



Try to reduce SIGLENINT in tsearch2/gistidx.h up to 8 (do not forget reindex !!)
and try it....

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/