| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Phillip Berry <pberry(at)stellaconcepts(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes |
| Date: | 2010-03-11 08:45:02 |
| Message-ID: | 4B98AD8E.1030906@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carsten Kropf | 2010-03-11 11:24:41 | Replacing an index item |
| Previous Message | A. Kretschmer | 2010-03-11 07:34:59 | Re: Statement Triggers |