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 7416F11F66CA for ; Thu, 6 Apr 2006 13:18:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99926-06 for ; Thu, 6 Apr 2006 13:18:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id E5DC511F66C1 for ; Thu, 6 Apr 2006 13:18:05 -0300 (ADT) Received: from 172.16.1.148 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Thu, 06 Apr 2006 12:17:49 -0400 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01HOST02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 6 Apr 2006 12:17:40 -0400 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Thu, 6 Apr 2006 16:17:40 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Thu, 06 Apr 2006 09:17:39 -0700 Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3 From: "Luke Lonergan" To: newz@bearfruit.org, "Juan Casero (FL FLC)" cc: pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3 Thread-Index: AcZZgs09F76VeQ92Q4y8YXLIANZEqQAEtJk4 In-Reply-To: MIME-Version: 1.0 X-OriginalArrivalTime: 06 Apr 2006 16:17:40.0619 (UTC) FILETIME=[A09B9DB0:01C65995] X-WSS-ID: 682BE0942XS40889080-04-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.373 required=5 tests=[AWL=0.120, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.373 X-Spam-Level: * X-Archive-Number: 200604/116 X-Sequence-Number: 18200 Juan, On 4/6/06 7:01 AM, "Matthew Nuzum" wrote: >> Apart from that since I will only get this one chance to >> buy a new server for data processing I need to make sure that I buy >> something that can grow over time as our needs change. I don't want to >> buy a server only to find out later that it cannot meet our needs with >> future database projects. I have to balance a limited budget, room for >> future performance growth, and current system requirements. Trust me it >> isn't easy. > > Isn't it about time we had our annual "what kind of server can I get > for $8k" thread? Based on Juan's description, here's a config that will *definitely* be the fastest possible in an $8K budget: Buy a dual opteron server with 8 x 400GB SATA II disks on a 3Ware 9550SX RAID controller with 16GB of RAM pre-installed with Centos 4.3 for $6,000 here: http://www.asacomputers.com/ Download the *free* open source Bizgres here: http://bgn.greenplum.com/ Use bitmap indexes for columns with less than 10,000 unique values, and your system will fly through 100GB. This is the fastest OSS business intelligence kit for the money, guaranteed. - Luke