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@xxxxxxxxx
WWW: http://www.sigaev.ru/
