Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D30CD9FA4ED for ; Fri, 2 Mar 2007 05:10:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 28437-09 for ; Fri, 2 Mar 2007 05:10:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from bioscene.co.jp (pee5980.hyogff01.ap.so-net.ne.jp [202.238.89.128]) by postgresql.org (Postfix) with SMTP id 07A6B9FA2FD for ; Fri, 2 Mar 2007 05:10:16 -0400 (AST) Received: (qmail 28873 invoked from network); 2 Mar 2007 09:11:52 -0000 Received: from unknown (HELO eth0.sonoda) (192.168.2.5) by bioscene.co.jp with SMTP; 2 Mar 2007 09:11:52 -0000 Subject: Re: Improving query performance From: David Leangen Reply-To: postgres@leangen.net To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <1763.1172814488@sss.pgh.pa.us> References: <1172808030.27446.12.camel@sonoda.bioscene.co.jp> <1763.1172814488@sss.pgh.pa.us> Content-Type: text/plain Date: Fri, 02 Mar 2007 18:06:06 +0900 Message-Id: <1172826366.27446.16.camel@sonoda.bioscene.co.jp> Mime-Version: 1.0 X-Mailer: Evolution 2.6.0 (2.6.0-1) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.186 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/50 X-Sequence-Number: 23455 > > And this is the actual query: > > I think you need to look into full-text indexing (see tsearch2). Thanks, Tom. Yes, we know this. This is just a temporary fix that we needed to get up today for biz reasons. Implementing full-text searching within a few short hours was out of the question. Anyway, we found a temporary solution. We'll be doing this "properly" later. Thanks for taking the time to suggest this. Cheers, Dave