Re: Index Usage and Running Times by FullTextSearch with prefix matching

rawi <only4com(at)web(dot)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