From: Jesper Krogh <jesper@krogh.cc>
To: pgsql-performance@postgresql.org
Subject: Re: Request for feedback on hardware for a new database server
Date: Fri, 18 Mar 2011 07:19:04 +0100
Message-ID: <4D82F958.3080805@krogh.cc> (raw)
In-Reply-To: <871v25jlnb.fsf@googlemail.com>
References: <871v25jlnb.fsf@googlemail.com>
On 2011-03-18 01:51, Oliver Charles wrote:
> Hello,
>
> At MusicBrainz we're looking to get a new database server, and are
> hoping to buy this in the next couple of days. I'm mostly a software
> guy, but I'm posting this on behalf of Rob, who's actually going to be
> buying the hardware. Here's a quote of what we're looking to get:
I think most of it has been said already:
* Battery backed write cache
* See if you can get enough memory to make all of your "active"
dataset fit in memory. (typically not that hard in 2011).
* Dependent on your workload of-course, you're typically not
bottlenecked by the amount of cpu-cores, so strive for fewer
faster cores.
* As few sockets as you can screeze you memory and cpu-requirements
onto.
* If you can live with (or design around) the tradeoffs with SSD it
will buy you way more performance than any significant number
of rotating drives. (a good backup plan with full WAL-log to a second
system as an example).
--
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
Subject: Re: Request for feedback on hardware for a new database server
In-Reply-To: <4D82F958.3080805@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