From: Luke Lonergan <llonergan@greenplum.com>
To: newz@bearfruit.org, "Juan Casero (FL FLC)" <Juan.Casero@wholefoods.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Date: Thu, 06 Apr 2006 09:17:39 -0700
Message-ID: <C05A8D33.2100E%llonergan@greenplum.com> (raw)
In-Reply-To: <f3c0b4080604060701t1d916775kd7e980ba2ec8109a@mail.gmail.com>
Juan,
On 4/6/06 7:01 AM, "Matthew Nuzum" <mattnuzum@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: llonergan@greenplum.com, Juan.Casero@wholefoods.com
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
In-Reply-To: <C05A8D33.2100E%llonergan@greenplum.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox