Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group