Message-ID: <4E208BB0.4010804@gmx.net>
Date: Fri, 15 Jul 2011 11:49:20 -0700
From: "chris r." <chricki@gmx.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de;
	rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Hardware advice for scalable warehouse db
References: <ivon1e$81d$1@dough.gmane.org> <4E1FE7ED.90909@2ndquadrant.com>
In-Reply-To: <4E1FE7ED.90909@2ndquadrant.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi list,

Thanks a lot for your very helpful feedback!

> I've tested MD1000, MD1200, and MD1220 arrays before, and always gotten
> seriously good performance relative to the dollars spent
Great hint, but I'm afraid that's too expensive for us. But it's a great
way to scale over the years, I'll keep that in mind.

I had a look at other server vendors who offer 4U servers with slots for
16 disks for 4k in total (w/o disks), maybe that's an even
cheaper/better solution for us. If you had the choice between 16 x 2TB
SATA vs. a server with some SSDs for WAL/indexes and a SAN (with SATA
disk) for data, what would you choose performance-wise?

Again, thanks so much for your help.

Best,
Chris