X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id AC1C952851
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Jun 2005 13:41:08 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 82350-04
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Jun 2005 16:41:06 +0000 (GMT)
Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de
	[193.41.200.20])
	by svr1.postgresql.org (Postfix) with ESMTP id 37D285281C
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Jun 2005 13:41:04 -0300 (ADT)
Received: from 173-172-20-212.dsl.globvill.de ([212.20.172.173]
	helo=mail.office.turtle-entertainment.de)
	by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian))
	id 1Dg3bx-0004fD-00; Wed, 08 Jun 2005 18:41:02 +0200
Received: from [212.6.194.238] (helo=[212.6.194.238])
	by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7
	(Debian)) id 1Dg3bx-0007ZM-00; Wed, 08 Jun 2005 18:41:01 +0200
Message-ID: <42A71F9D.6040604@turtle-entertainment.de>
Date: Wed, 08 Jun 2005 18:41:01 +0200
From: Bjoern Metzdorf <bm@turtle-entertainment.de>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Rory Campbell-Lange <rory@campbell-lange.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help specifying new web server/database machine
References: <20050608163418.GA3327@campbell-lange.net>
In-Reply-To: <20050608163418.GA3327@campbell-lange.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.946 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200506/175
X-Sequence-Number: 12812

Hi,

Rory Campbell-Lange wrote:

  > We are considering two RAID1 system disks, and two RAID1 data disks.
> We've avoided buying Xeons. The machine we are looking at looks like
> this:
> 
>     Rackmount Chassis - 500W PSU / 4 x SATA Disk Drive Bays
>     S2882-D - Dual Opteron / AMD 8111 Chipset / 5 x PCI Slots
>     2x - (Dual) AMD Opteron 246 Processors (2.0GHz) - 1MB L2 Cache/core (single core)
>     2GB (2x 1024MB) DDR-400 (PC3200) ECC Registered SDRAM (single rank)

Make that 4 or 8 GB total. We have seen a huge boost in performance when 
we upgraded from 4 to 8 GB. Make sure to use a decent 64bit Linux.

>     4 Port AMCC/3Ware 9500-4LP PCI SATA RAID Controller
>     80GB SATA-150 7200RPM Hard Disk / 8MB Cache
>     80GB SATA-150 7200RPM Hard Disk / 8MB Cache
>     250GB SATA-150 7200RPM Hard Disk / 8MB Cache
>     250GB SATA-150 7200RPM Hard Disk / 8MB Cache

Three options:

9500-4LP with Raptor drives 10k rpm, raid 1 + raid 1
9500-8LP with Raptor drives 10k rpm, raid 10 + raid 1
Go for SCSI (LSI Megaraid or ICP Vortex) and take 10k drives

BBU option is always nice.

Regards,
Bjoern