|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
For random IO, the 3ware cards are better than PERC > Question: will 8*15k 73GB SCSI drives outperform 24*7K 320GB SATA II drives? Nope. Not even if the 15K 73GB HDs were the brand new Savvio 15K screamers. Example assuming 3.5" HDs and RAID 10 => 4 15K 73GB vs 12 7.2K 320GBThe 15K's are 2x faster rpm, but they are only ~23% the density => advantage per HD to SATAs. Then there's the fact that there are 1.5x as many 7.2K spindles as 15K spindles...
Unless your transactions are very small and unbuffered / unscheduled (in which case you are in a =lot= of trouble), The SATA set-up rates to be ~2x - ~3x faster ITRW than the SCSI set-up.
Cheers, Ron Peacetree At 06:13 PM 4/3/2007, jason@xxxxxxxxx wrote:
We need to upgrade a postgres server. I'm not tied to these specific alternatives, but I'm curious to get feedback on their general qualities. SCSI dual xeon 5120, 8GB ECC 8*73GB SCSI 15k drives (PERC 5/i) (dell poweredge 2900) SATA dual opteron 275, 8GB ECC 24*320GB SATA II 7.2k drives (2*12way 3ware cards) (generic vendor) Both boxes are about $8k running ubuntu. We're planning to setup with raid10. Our main requirement is highest TPS (focused on a lot of INSERTS). Question: will 8*15k SCSI drives outperform 24*7K SATA II drives? -jay ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Home] [Yosemite]