Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Markus Schiltknecht <markus(at)bluegap(dot)ch> writes:
> Henrik Zagerholm wrote:
>> 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?

Also, I wonder how much of the time went into to_tsvector() and how much
into updating the GIST or GIN index that I suppose is on the column.
For a full update like this it might make sense to drop the index,
update the column, rebuild the index from scratch.

			regards, tom lane