Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

[Andrew G. Hammond]

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




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend