X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 858EA9DCAE1 for ; Wed, 7 Dec 2005 03:56:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57120-03 for ; Wed, 7 Dec 2005 03:56:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 1F4B29DCB52 for ; Wed, 7 Dec 2005 03:56:20 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id F163B3093C; Wed, 7 Dec 2005 08:56:17 +0100 (MET) From: Michael Riess X-Newsgroups: pgsql.performance Subject: Re: TSearch2 vs. Apache Lucene Date: Wed, 07 Dec 2005 08:56:18 +0100 Organization: Hub.Org Networking Services Lines: 35 Message-ID: References: <43963D9B.4020605@familyhealth.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5 (Windows/20051025) In-Reply-To: <43963D9B.4020605@familyhealth.com.au> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/223 X-Sequence-Number: 16044 No, my problem is that using TSearch2 interferes with other core components of postgres like (auto)vacuum or dump/restore. > ... > > So you'll avoid a non-core product and instead only use another non-core > product...? > > Chris > > Michael Riess wrote: >> >>> Has anyone ever compared TSearch2 to Lucene, as far as performance is >>> concerned? >> >> >> I'll stay away from TSearch2 until it is fully integrated in the >> postgres core (like "create index foo_text on foo (texta, textb) USING >> TSearch2"). Because a full integration is unlikely to happen in the >> near future (as far as I know), I'll stick to Lucene. >> >> Mike >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >