Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 21 Feb 2007 12:09:14 +0100
- Message-id: <45DC285A(dot)4010106(at)bluegap(dot)ch>
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
- Follow-Ups:
- Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
- From: Tom Lane
- Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
- References:
- Slow running to_tsvector (tsearch2 in PG 8.2.3)
- From: Henrik Zagerholm
- Slow running to_tsvector (tsearch2 in PG 8.2.3)
- Prev by Date: Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
- Next by Date: Re: postgresql vs mysql
- Previous by thread: Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
- Next by thread: Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
- Indexes: