Re: Hardware suggestions for Linux/PGSQL server - Mailing list pgsql-performance

From Andrew G. Hammond
Subject Re: Hardware suggestions for Linux/PGSQL server
Date
Msg-id 3FDD35CF.6080103@xyzzy.dhs.org
Whole thread Raw
In response to Re: Hardware suggestions for Linux/PGSQL server  (Jeff Bohmer <bohmer@visionlink.org>)
List 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




pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: Tables Without OIDS and its effect
Next
From: Christopher Browne
Date:
Subject: Re: Hardware suggestions for Linux/PGSQL server