From: | Ron <rjpeace(at)earthlink(dot)net> |
---|---|
To: | "jason(at)ohloh(dot)net" <jason(at)ohloh(dot)net>,pgsql-performance(at)postgresql(dot)org |
Subject: | Re: SCSI vs SATA |
Date: | 2007-04-03 23:07:52 |
Message-ID: | E1HYs6Y-0008O5-SN@elasmtp-banded.atl.sa.earthlink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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 320GB
The 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(at)ohloh(dot)net 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2007-04-03 23:13:02 | Re: SCSI vs SATA |
Previous Message | Alex Deucher | 2007-04-03 22:17:20 | Re: postgres 7.4 vs 8.x redux: query plans |