Re: Hardware recommendation: which is best

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Hardware recommendation: which is best
Дата
Msg-id Pine.GSO.4.64.0709111114120.24969@westnet.com
обсуждение исходный текст
Ответ на Re: Hardware recommendation: which is best  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Ответы Re: Hardware recommendation: which is best  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Список pgsql-general
On Tue, 11 Sep 2007, Phoenix Kiula wrote:

> I'll have a raid controller in both scenarios, but which RAID should
> be better: RAID1 or RAID10?

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.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: "Phoenix Kiula"
Дата:
Сообщение: Re: Partial index with regexp not working
Следующее
От: Jeff Lanzarotta
Дата:
Сообщение: Question about a query with two count fields