Slow running to_tsvector (tsearch2 in PG 8.2.3)
- From: Henrik Zagerholm <henke(at)mac(dot)se>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Slow running to_tsvector (tsearch2 in PG 8.2.3)
- Date: Wed, 21 Feb 2007 10:59:32 +0100
- Message-id: <81E2F3F6-0543-4D78-B205-3EC575D3A081(at)mac(dot)se>
Hello list,
I've been testing tsearch2 for a while and I recently noticed some
really slow queries.
This is a quite big document so the times are maybe accurate.
The document has about 194 000 words.
I put all the data in tbl_fulltext.fulltext_text and then did a
update tbl_fulltext set vectors = to_tsvector(fulltext_text);
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()?
Regards,
Henrik
Home |
Main Index |
Thread Index