Le mercredi 21 février 2007 15:44, Tom Lane a écrit : > Markus Schiltknecht <markus@xxxxxxxxxx> 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. a count of distinct word in those 194 000 can be interesting also, I presume. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
