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 01B52329D27 for ; Thu, 9 Sep 2004 15:14: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 49686-07 for ; Thu, 9 Sep 2004 14:14:47 +0000 (GMT) Received: from mail.mailsnare.net (v187.mailsnare.net [206.246.200.187]) by svr1.postgresql.org (Postfix) with ESMTP id E8568329CE3 for ; Thu, 9 Sep 2004 15:14:49 +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 E3C1F971F2 for ; Thu, 9 Sep 2004 14:14:39 +0000 (UTC) Message-ID: <4140654A.1000407@portalvu.com> Date: Thu, 09 Sep 2004 09:14:34 -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: Re: Text Search vs MYSQL vs Lucene References: <414052F4.5050000@portalvu.com> <200409091909.33934.shridhar@frodo.hserus.net> In-Reply-To: <200409091909.33934.shridhar@frodo.hserus.net> 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/395 X-Sequence-Number: 65601 It be at least dual opteron 64 w 4 gigs of ram runing fedora with a huge raid striped drives as single volume. A similar system and types of querries would be this: http://marc.theaimsgroup.com So I guess a table scan. .V Shridhar Daithankar wrote: >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 > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > -- Please post on Rich Internet Applications User Interface (RiA/SoA)