Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BDCBC2E014F for ; Wed, 13 Feb 2008 13:38:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07218-09 for ; Wed, 13 Feb 2008 13:38:31 -0400 (AST) Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 7A3B12E00B4 for ; Wed, 13 Feb 2008 13:38:31 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m1DHcSWX020059; Wed, 13 Feb 2008 12:38:28 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m1DHcSYU020056; Wed, 13 Feb 2008 12:38:28 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Wed, 13 Feb 2008 12:38:28 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Rory Campbell-Lange cc: PGSQL Performance Subject: Re: Small DB Server Advice In-Reply-To: <20080213131206.GA18969@campbell-lange.net> Message-ID: References: <20080213131206.GA18969@campbell-lange.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/141 X-Sequence-Number: 28683 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