Re: SCSI vs SATA

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: "jason(at)ohloh(dot)net" <jason(at)ohloh(dot)net>
Subject: Re: SCSI vs SATA
Date: 2007-04-04 08:36:53
Message-ID: 461363A5.1080709@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

jason(at)ohloh(dot)net wrote:
> 8*73GB SCSI 15k ...(dell poweredge 2900)...
> 24*320GB SATA II 7.2k ...(generic vendor)...
>
> 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?

It's worth asking the vendors in question if you can test the configurations
before you buy. Of course with 'generic vendor' it's easiest if that
vendor has local offices.

If Dell hesitates, mention that their competitors offer such programs;
some by loaning you the servers[1], others by having performance testing
centers where you can (for a fee?) come in and benchmark your applications[2].

[1] http://www.sun.com/tryandbuy/
[2] http://www.hp.com/products1/solutioncenters/services/index.html#solution

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Arnau 2007-04-04 08:50:48 Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
Previous Message Eugene Ogurtsov 2007-04-04 06:07:20 postgresql.conf file for PostgreSQL 8.2.3