Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group