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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
