Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id B346AB5DC1F
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 15 Jul 2011 05:23:10 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 99551-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 15 Jul 2011 08:23:04 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from shrek.krogh.cc (2605ds1-ynoe.0.fullrate.dk [90.184.12.24])
	by mail.postgresql.org (Postfix) with ESMTP id A204DB5DC17
	for <pgsql-performance@postgresql.org>;
	Fri, 15 Jul 2011 05:23:04 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by shrek.krogh.cc (Postfix) with ESMTP id 4FEA53317CB;
	Fri, 15 Jul 2011 10:23:02 +0200 (CEST)
X-Virus-Scanned: Debian amavisd-new at shrek.krogh.cc
Received: from shrek.krogh.cc ([127.0.0.1])
	by localhost (shrek.krogh.cc [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id cjDeakh76hws; Fri, 15 Jul 2011 10:22:59 +0200 (CEST)
Received: from shrek.krogh.cc (localhost [127.0.0.1])
	by shrek.krogh.cc (Postfix) with ESMTP id 111DD1D5C39;
	Fri, 15 Jul 2011 10:22:58 +0200 (CEST)
Received: from 81.223.30.46 (proxying for 172.30.2.14)
	(SquirrelMail authenticated user jesper@krogh.cc)
	by shrek.krogh.cc with HTTP; Fri, 15 Jul 2011 10:22:59 +0200 (CEST)
Message-ID: <4dde2344d7a0c36fbac3b61a667bd99d.squirrel@shrek.krogh.cc>
In-Reply-To: <ivon1e$81d$1@dough.gmane.org>
References: <ivon1e$81d$1@dough.gmane.org>
Date: Fri, 15 Jul 2011 10:22:59 +0200 (CEST)
Subject: Re: Hardware advice for scalable warehouse db
From: jesper@krogh.cc
To: "chris" <chricki@gmx.net>
Cc: pgsql-performance@postgresql.org
User-Agent: SquirrelMail/1.4.15
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5
	tests=BAYES_40=-0.001
X-Spam-Level: 
X-Archive-Number: 201107/156
X-Sequence-Number: 44368

>   1 x Intel Xeon X5670, 6C, 2.93GHz, 12M Cache
>   16 GB (4x4GB) Low Volt DDR3 1066Mhz
>   PERC H700 SAS RAID controller
>   4 x 300 GB 10k SAS 6Gbps 2.5" in RAID 10

Apart from Gregs excellent recommendations. I would strongly suggest
more memory. 16GB in 2011 is really on the low side.

PG is using memory (either shared_buffers og OS cache) for
keeping frequently accessed data in. Good recommendations are hard
without knowledge of data and access-patterns, but 64, 128 and 256GB
system are quite frequent when you have data that can't all be
in memory at once.

SAN's are nice, but I think you can buy a good DAS thing each year
for just the support cost of a Netapp, but you might have gotten a
really good deal there too. But you are getting a huge amount of
advanced configuration features and potential ways of sharing and..
and .. just see the specs.

.. and if you need those the SAN is a good way to go, but
they do come with a huge pricetag.

Jesper