From: jesper@krogh.cc
To: chris <chricki@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware advice for scalable warehouse db
Date: Fri, 15 Jul 2011 10:22:59 +0200 (CEST)
Message-ID: <4dde2344d7a0c36fbac3b61a667bd99d.squirrel@shrek.krogh.cc> (raw)
In-Reply-To: <ivon1e$81d$1@dough.gmane.org>
References: <ivon1e$81d$1@dough.gmane.org>
> 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
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: jesper@krogh.cc, chricki@gmx.net
Subject: Re: Hardware advice for scalable warehouse db
In-Reply-To: <4dde2344d7a0c36fbac3b61a667bd99d.squirrel@shrek.krogh.cc>
* 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