Re: Help specifying new web server/database machine - Mailing 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