Re: Hardware recommendation: which is best

Поиск
Список
Период
Сортировка
От Franz.Rasper@izb.de
Тема Re: Hardware recommendation: which is best
Дата
Msg-id 11EC9A592C31034C88965C87AF18C2A702B8369F@m0000s61
обсуждение исходный текст
Ответ на Hardware recommendation: which is best  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Список pgsql-general
>The point people are trying to make to you is that the differences between
>RAID controllers can be as big as that between RAID architectures in cases
>like yours.  Which controller you're using and how the cache is setup can
>have a larger impact on INSERT performance than how many/what type of
>disks are involved.  If you've comparing a fast SAS controller to a slow
>SATA2 one, than the SAS setup may very well run faster no matter how many
>disks the SATA2 one has.  Conversely, it's not unheard of to have a SAS
>controller with such miserable operating system drivers that there is no
>performance advantage to using faster SCSI disks instead of SATA2.

>You're not going to get a particularly useful answer here without giving
>some specifics about the two disk controllers you're comparing, how much
>cache they have, and whether they include a battery backup.

Exactly, thats the point.

В списке pgsql-general по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Question about a query with two count fields
Следующее
От: "Rodrigo De León"
Дата:
Сообщение: Re: avg() of array values