Re: Hardware suggestions for Linux/PGSQL server

Andrew G. Hammond <drew@xyzzy.dhs.org>

From: "Andrew G. Hammond" <drew@xyzzy.dhs.org>
To: Jeff Bohmer <bohmer@visionlink.org>
Cc: pgsql-performance@postgresql.org
Date: 2003-12-15T04:17:19Z
Lists: pgsql-performance
I don't know what your budget is, but there are now 10k RPM SATA 150 
drives on the market. Their price/performance is impressive. You may 
want to consider going with a bunch of these instead of SCSI disks (more 
spindles vs. faster spindles). 3ware makes a hardware raid card that can 
drive up to 12 SATA disks. I have been told by a few people who have 
used it that the linux driver is very solid.

Drew


Jeff Bohmer wrote:

>> Just one more piece of advice, you might want to look into a good 
>> battery
>> backed cache hardware RAID controller.  They work quite well for heavily
>> updated databases.  The more drives you throw at the RAID array the 
>> faster
>> it will be.
>
>
> I've seen this list often recommended such a setup.  We'll probably 
> get battery-backed write cache and start out with a 4 disk RAID 10 
> array.  Then add more disks and change RAID 5 if more read performance 
> is needed.
>
> Thanks,
> - Jeff