Re: Performance issue using Tsearch2 - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: Performance issue using Tsearch2
Date
Msg-id 1d4e0c10802050548u2ebbc553na46ea977a78febd1@mail.gmail.com
Whole thread Raw
In response to Performance issue using Tsearch2  ("Viviane Lestic" <vlestic@gmail.com>)
Responses Re: Performance issue using Tsearch2
List pgsql-performance
On Feb 5, 2008 12:47 PM, Viviane Lestic <vlestic@gmail.com> wrote:
> Could someone help me analyze this problem?
> I don't manage to see if the problem comes from bad tsearch tuning,
> postgresql configuration, or something else...

Can you try to replace zoneindex_test @@ q with zoneindex_test @@
to_tsquery('partir')? Increasing the statistics for zoneindex_test may
be a good idea too (see ALTER TABLE ... ALTER COLUMN doc).
I'm surprised you have the word "partir" in so many documents? Do you
use real data?

--
Guillaume

pgsql-performance by date:

Previous
From: Ansgar -59cobalt- Wiechers
Date:
Subject: Re: Performance issue using Tsearch2
Next
From: Dimitri Fontaine
Date:
Subject: Re: Benchmark Data requested