Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes - Mailing list pgsql-general

From Greg Smith
Subject Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes
Date
Msg-id 4B98AD8E.1030906@2ndquadrant.com
Whole thread Raw
In response to Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes  (Phillip Berry <pberry@stellaconcepts.com>)
List pgsql-general
Phillip Berry wrote:
> Hardware raid controller for both options, but I'm not sure what brand
> (yet).

The reason you won't ever find a good general answer to this question is
that it's so close that you need to know the exact controller cards and
the disks used in each situation to have any hope of guessing which will
work out better.  Sometimes you get lucky and one case has a know poor
performer, so you just get the other.  Next tiebreak is management
utilites, which count for a lot more than a small performance
difference.  If both are good on both of those, then maybe it's worth
the trouble to model each possibility against your workload, with
accurate numbers to substitute into any such guess.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Statement Triggers
Next
From: Carsten Kropf
Date:
Subject: Replacing an index item