Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 515722E0061 for ; Fri, 20 Jun 2008 10:13:10 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28343-02 for ; Fri, 20 Jun 2008 10:12:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ds528.dedicated.turbodns.co.uk (ds528.dedicated.turbodns.co.uk [81.21.72.118]) by developer.postgresql.org (Postfix) with ESMTP id 963472E0037 for ; Fri, 20 Jun 2008 10:12:57 -0300 (ADT) Received: (qmail 25411 invoked from network); 20 Jun 2008 13:12:54 -0000 Received: from howardnews@selestial.com by ds528.dedicated.turbodns.co.uk by uid 1005 with qmail-scanner-1.22 ( Clear:RC:1(62.3.231.11):. Processed in 0.022033 secs); 20 Jun 2008 13:12:54 -0000 Received: from unknown (HELO ?10.202.6.101?) (selestial-howard.cole@62.3.231.11) by ds528.dedicated.turbodns.co.uk with SMTP; 20 Jun 2008 13:12:54 -0000 Message-ID: <485BAC59.7070605@selestial.com> Date: Fri, 20 Jun 2008 14:10:49 +0100 From: Howard Cole User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Tsearch2 Initial Search Speed References: <4856A91F.1020001@selestial.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/102 X-Sequence-Number: 30452 PFC wrote: >> Hi, I am looking to improve the initial query speed for the following >> query: > > Try Xapian full text search engine, it behaves much better than > tsearch when the dataset exceeds your memory cache size. > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 3202 (20080620) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > Thanks for the heads-up PFC, but I prefer the tsearch2 license.