SCSI vs SATA - Mailing list pgsql-performance

From jason@ohloh.net
Subject SCSI vs SATA
Date
Msg-id 9C0858F5-0A48-4AF9-80FF-E4BA14F0F965@ohloh.net
Whole thread Raw
Responses Re: SCSI vs SATA  (Ron <rjpeace@earthlink.net>)
Re: SCSI vs SATA  ("Brian A. Seklecki" <lavalamp@spiritual-machines.org>)
Re: SCSI vs SATA  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Re: SCSI vs SATA  (Arjen van der Meijden <acmmailing@tweakers.net>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Alex Deucher"
Date:
Subject: Re: postgres 7.4 vs 8.x redux: query plans
Next
From: Ron
Date:
Subject: Re: SCSI vs SATA