Re: Performance issue using Tsearch2

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Viviane Lestic" <vlestic(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance issue using Tsearch2
Date: 2008-02-05 13:48:22
Message-ID: 1d4e0c10802050548u2ebbc553na46ea977a78febd1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

--
Guillaume

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri Fontaine 2008-02-05 14:06:48 Re: Benchmark Data requested
Previous Message Ansgar -59cobalt- Wiechers 2008-02-05 13:36:02 Re: Performance issue using Tsearch2