Re: Help specifying new web server/database machine - Mailing list pgsql-performance

From Bjoern Metzdorf
Subject Re: Help specifying new web server/database machine
Date
Msg-id 42A71F9D.6040604@turtle-entertainment.de
Whole thread Raw
In response to Help specifying new web server/database machine  (Rory Campbell-Lange <rory@campbell-lange.net>)
Responses Re: Help specifying new web server/database machine
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Help specifying new web server/database machine
Next
From: Tom Arthurs
Date:
Subject: Re: Postgresql on an AMD64 machine