From: Guillaume Smet <guillaume.smet@gmail.com>
To: Viviane Lestic <vlestic@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance issue using Tsearch2
Date: Tue, 5 Feb 2008 14:48:22 +0100
Message-ID: <1d4e0c10802050548u2ebbc553na46ea977a78febd1@mail.gmail.com> (raw)
In-Reply-To: <caec019b0802050347t4cd46203w7d087d3d51ac2b11@mail.gmail.com>
References: <caec019b0802050347t4cd46203w7d087d3d51ac2b11@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume.smet@gmail.com, vlestic@gmail.com
Subject: Re: Performance issue using Tsearch2
In-Reply-To: <1d4e0c10802050548u2ebbc553na46ea977a78febd1@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox