Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 79A292E3616 for ; Tue, 5 Feb 2008 09:50:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05509-01-5 for ; Tue, 5 Feb 2008 09:49:43 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by postgresql.org (Postfix) with ESMTP id CA2402E3D09 for ; Tue, 5 Feb 2008 09:48:24 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so3379760waf.5 for ; Tue, 05 Feb 2008 05:48:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=x90UFgIxVmdjmvVRXXrR49zXSA0Beweaxvc8Id9FtPc=; b=d0wanZ2ux/QpbkaYK6Rt6tr3CzXQro8Nheik0dm9l0NOLtM7CcJ5tuxDpH1Pw1fJ6T+lJRxJCm4DymrgLIEus2dFhH9zbJAks8mnr1qBP5vXG/RSBwEj40oM4NlSO/tww9bJL4A+rr98D90DsO7GV1PC2KnBGssq8t+yHOO3EO8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YpzGeo1gZeYN9MoFZ4B2XqtIRHlYE3vh1o52aIuqA4JYKlxHI05FHevPdRN4uM6dGlxjxqB7fYPuyz1BDyeTXzUqxvu0i2Dne2WiXD/CoPU5rX5GzeEOZLVU0+6CFxrS3VsH7+VmVzR/mPJKMPOxyOH/dSbjZRTyOIAdKDnEatM= Received: by 10.114.181.1 with SMTP id d1mr1575161waf.10.1202219302984; Tue, 05 Feb 2008 05:48:22 -0800 (PST) Received: by 10.114.103.11 with HTTP; Tue, 5 Feb 2008 05:48:22 -0800 (PST) Message-ID: <1d4e0c10802050548u2ebbc553na46ea977a78febd1@mail.gmail.com> Date: Tue, 5 Feb 2008 14:48:22 +0100 From: "Guillaume Smet" To: "Viviane Lestic" Subject: Re: Performance issue using Tsearch2 Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/28 X-Sequence-Number: 28570 On Feb 5, 2008 12:47 PM, Viviane Lestic 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