From: Greg Smith <gsmith@gregsmith.com>
To: Rory Campbell-Lange <rory@campbell-lange.net>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Small DB Server Advice
Date: Wed, 13 Feb 2008 12:38:28 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0802131225440.11402@westnet.com> (raw)
In-Reply-To: <20080213131206.GA18969@campbell-lange.net>
References: <20080213131206.GA18969@campbell-lange.net>
On Wed, 13 Feb 2008, Rory Campbell-Lange wrote:
> (https://secure.dnuk.com/systems/r325hs-1u.php?configuration=7766)
> 4 x 147GB 15000 rpm SCSI in RAID 10 with 320-1 RAID CARD + 64MB cache BBU
That's running the LSI Megaraid SCSI controller. Those are solid but not
the best performers in their class, particularly on writes. But given
your application description (1GB data in a year and read-heavy) that card
running a 4-spindle RAID10 should be overkill.
> I'm particularly out of date about the best processors to go for. DNUK
> also have Opteron as an option.
Current Intel chips benchmark better, occasionally you'll find people who
claim the better multi-CPU memory model in the Opteron systems give them
better performance at high loads but that's difficult to quantify.
There's not a huge difference in any case. You're probably going to
bottleneck on either disk or how fast DDR2 memory goes anyway and both
sets of products are competative right now.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com, rory@campbell-lange.net
Subject: Re: Small DB Server Advice
In-Reply-To: <Pine.GSO.4.64.0802131225440.11402@westnet.com>
* 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