X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ADB3A329DCD for ; Thu, 9 Sep 2004 13:56:31 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13447-10 for ; Thu, 9 Sep 2004 12:56:25 +0000 (GMT) Received: from mail.mailsnare.net (v187.mailsnare.net [206.246.200.187]) by svr1.postgresql.org (Postfix) with ESMTP id D7D46329CF7 for ; Thu, 9 Sep 2004 13:56:25 +0100 (BST) Received: from [172.16.1.33] (adsl-70-241-42-93.dsl.rcsntx.swbell.net [70.241.42.93]) by mail.mailsnare.net (Postfix) with ESMTP id BF0E1971E9 for ; Thu, 9 Sep 2004 12:56:24 +0000 (UTC) Message-ID: <414052F4.5050000@portalvu.com> Date: Thu, 09 Sep 2004 07:56:20 -0500 From: Vic Cekvenich Reply-To: vic.cekvenich@portalvu.com User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Text Search vs MYSQL vs Lucene Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by ClamAV at mailsnare.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/386 X-Sequence-Number: 65592 What would be performance of pgSQL text search vs MySQL vs Lucene (flat file) for a 2 terabyte db? thanks for any comments. .V -- Please post on Rich Internet Applications User Interface (RiA/SoA)