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