On Feb 5, 2008 12:47 PM, Viviane Lestic <vlestic(at)gmail(dot)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?
In response to
pgsql-performance by date
|Next:||From: Dimitri Fontaine||Date: 2008-02-05 14:06:48|
|Subject: Re: Benchmark Data requested|
|Previous:||From: Ansgar -59cobalt- Wiechers||Date: 2008-02-05 13:36:02|
|Subject: Re: Performance issue using Tsearch2|