Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1081F9FB385 for ; Wed, 4 Apr 2007 05:37:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36626-02-6 for ; Wed, 4 Apr 2007 05:36:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id EC82E9FBA1D for ; Wed, 4 Apr 2007 05:36:58 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id A47CD30909; Wed, 4 Apr 2007 10:36:57 +0200 (MET DST) From: Ron Mayer X-Newsgroups: pgsql.performance Subject: Re: SCSI vs SATA Date: Wed, 04 Apr 2007 01:36:53 -0700 Organization: Hub.Org Networking Services Lines: 18 Message-ID: <461363A5.1080709@cheapcomplexdevices.com> References: <9C0858F5-0A48-4AF9-80FF-E4BA14F0F965@ohloh.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: "jason@ohloh.net" User-Agent: Icedove 1.5.0.10 (X11/20070307) In-Reply-To: <9C0858F5-0A48-4AF9-80FF-E4BA14F0F965@ohloh.net> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/52 X-Sequence-Number: 23929 jason@ohloh.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