Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes

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