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

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes
Дата
Msg-id 4B98AD8E.1030906@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes  (Phillip Berry <pberry@stellaconcepts.com>)
Список 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 по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Statement Triggers
Следующее
От: Carsten Kropf
Дата:
Сообщение: Replacing an index item