Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AB2F19F9603 for ; Wed, 22 Aug 2007 17:30:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 90024-03 for ; Wed, 22 Aug 2007 17:30:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id ACD689F9505 for ; Wed, 22 Aug 2007 17:30:27 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id C5C8F3144D; Wed, 22 Aug 2007 22:30:26 +0200 (MET DST) From: "Carlo Stonebanks" X-Newsgroups: pgsql.performance Subject: Re: Fast tsearch2, trigram matching on short phrases Date: Wed, 22 Aug 2007 16:31:08 -0400 Organization: Hub.Org Networking Services Lines: 11 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org In-Reply-To: X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Windows Mail 6.0.6000.16480 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480 To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL=0.001, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200708/247 X-Sequence-Number: 26377 Hi Oleg, > you didn't show us explain analyze of your select. I didn't because I didn't expect any reaction to it - my understanding is that trigram matching for phrases is not recommended because of the performance. Do you believe that I SHOULD expect good performance from trigram matching on phrases (a sopposed to words)? Carlo