Re: Index Usage and Running Times by FullTextSearch with prefix matching - Mailing list pgsql-sql

rawi <only4com@web.de> writes:
> And querying: FTS with prefix matching:

> SELECT count(a)
> FROM t1
> WHERE a_tsvector @@ to_tsquery('aaa:* & b:* & c:* & d:*')

> (RESULT: count: 619)
> Total query runtime: 21266 ms.

FWIW, I get fairly decent performance for cases like this in HEAD
(at least with a GIN index; GIST seems much less able to do well with
short prefixes).  What PG version are you testing?
        regards, tom lane