Tom Lane-2 wrote
> rawi <
> only4com@
> > 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 ca
rawi wrote
>
> Tom Lane-2 wrote
>> 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?
> Thank you Tom,
>
> I'm testing on PG 9.1 on UbuntuServer 12.10, 64b
Tom Lane-2 wrote
> 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).
Short or long prefixes seem to be equaly unfavorable. Even with the full
length of the words, but queried as prefix I get
Tom Lane-2 wrote
> 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?
Thank you Tom,
I'm testing on PG 9.1 on UbuntuServer 12.10, 64bit
I'll update to 9.2 t
