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 C677B329E8C; Thu, 9 Sep 2004 14:39:53 +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 33753-08; Thu, 9 Sep 2004 13:39:42 +0000 (GMT) Received: from frodo.hserus.net (frodo.hserus.net [204.74.68.40]) by svr1.postgresql.org (Postfix) with ESMTP id EB906329E8A; Thu, 9 Sep 2004 14:39:45 +0100 (BST) Received: from [203.199.147.2] (port=34854 helo=ps0499.persistent.co.in) by frodo.hserus.net with esmtpsa (Cipher TLSv1:RC4-MD5:128) (Exim 4.42 #0) id 1C5P9N-000NLB-59 by authid with plain; Thu, 09 Sep 2004 19:09:45 +0530 From: Shridhar Daithankar To: vic.cekvenich@portalvu.com Subject: Re: Text Search vs MYSQL vs Lucene Date: Thu, 9 Sep 2004 19:09:33 +0530 User-Agent: KMail/1.7 Cc: pgsql-general@postgresql.org, pgsql-performance@postgresql.org References: <414052F4.5050000@portalvu.com> In-Reply-To: <414052F4.5050000@portalvu.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200409091909.33934.shridhar@frodo.hserus.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/391 X-Sequence-Number: 65597 On Thursday 09 Sep 2004 6:26 pm, Vic Cekvenich wrote: > What would be performance of pgSQL text search vs MySQL vs Lucene (flat > file) for a 2 terabyte db? Well, it depends upon lot of factors. There are few questions to be asked here.. - What is your hardware and OS configuration? - What type of data you are dealing with? Mostly static or frequently updated? - What type of query you are doing. Aggregates or table scan or selective retreival etc. Unfortunately there is no one good answer. If you could provide details, it would help a lot.. Shridhar