Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)

[Markus Schiltknecht <markus@xxxxxxxxxx>]

Hi,

Henrik Zagerholm wrote:
> Which takes about 80 seconds to complete.
> The hardware is a Pentium 4 2.8GHz with 1GB HyperX memory.
>
> Is this normal? What can I tweak in postgresql.conf to speed up big 
> to_tsvector()?

Hm.. seems not too unreasonable to me.

Take a look at the stemmers or dictionaries involved. What do you use there?

Regards

Markus