From: cluster <skrald@amossen.dk>
To: pgsql-performance@postgresql.org
Subject: Best hardware/cost tradoff?
Date: Thu, 28 Aug 2008 21:22:38 +0200
Message-ID: <g96ttt$2l3m$1@news.hub.org> (raw)
I'm about to buy a combined web- and database server. When (if) the site
gets sufficiently popular, we will split the database out to a separate
server.
Our budget is limited, so how should we prioritize?
* We think about buying some HP Proliant server with at least 4GB ram
and at least a duo core processor. Possibly quad core. The OS will be
debian/Linux.
* Much of the database will fit in RAM so it is not *that* necessary to
prefer the more expensive SAS 10000 RPM drives to the cheaper 7500 RPM
SATA drives, is it? There will both be many read- and write queries and
a *lot* (!) of random reads.
* I think we will go for hardware-based RAID 1 with a good
battery-backed-up controller. I have read that software RAID perform
surprisingly good, but for a production site where hotplug replacement
of dead disks is required, is software RAID still worth it?
Anything else we should be aware of?
Thanks!
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: skrald@amossen.dk
Subject: Re: Best hardware/cost tradoff?
In-Reply-To: <g96ttt$2l3m$1@news.hub.org>
* 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