> 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/