Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: Henrik Zagerholm <henke(at)mac(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
Date: 2007-02-21 11:09:14
Message-ID: 45DC285A.4010106@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chad Wagner 2007-02-21 11:31:10 Re: postgresql vs mysql
Previous Message Richard Huxton 2007-02-21 11:05:58 Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)