Re: What's the best hardver for PostgreSQL 8.1?

Поиск
Список
Период
Сортировка
От Luke Lonergan
Тема Re: What's the best hardver for PostgreSQL 8.1?
Дата
Msg-id 3E37B936B592014B978C4415F90D662D01F47553@MI8NYCMAIL06.Mi8.com
обсуждение исходный текст
Ответ на Re: What's the best hardver for PostgreSQL 8.1?  ("Luke Lonergan" <LLonergan@greenplum.com>)
Ответы Re: What's the best hardver for PostgreSQL 8.1?  (Benjamin Arai <barai@cs.ucr.edu>)
Список pgsql-performance
Benjamin,

> Have you done any benchmarking of the 9550SX against a software raid configuration?


Interesting - no, not on SATA, mostly because I've had awful luck with Linux drivers and SATA.  The popular
manufacturersof SATA to PCI bridge chipsets are Silicon Image and Highpoint, and I've not seen Linux work with them at
anyreasonable performance yet.  I've also had problems with Adaptec's cards - I think they manufacture their own SATA
toPCI chipset as well.  So far, I've only had good luck with the on-chipset Intel SATA implementation.  I think the
problemsI've had could be entirely driver-related, but in the end it doesn't matter if you can't find drivers that work
forLinux. 

The other problem is getting enough SATA connections for the number of disks we want.  I do have two new Areca SATA
RAIDcards and I'm going to benchmark those against the 3Ware 9550SX with 2 x 8 = 16 disks on one host. 

I guess we could run the HW RAID controllers in JBOD mode to get a good driver / chipset configuration for software
RAID,but frankly I prefer HW RAID if it performs well.  So far the SATA host-based RAID is blowing the doors off of
everyother HW RAID solution I've tested. 

- Luke


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

Предыдущее
От: Benjamin Arai
Дата:
Сообщение: Re: What's the best hardver for PostgreSQL 8.1?
Следующее
От: Gourish Singbal
Дата:
Сообщение: Fwd: vacuuming template0 gave ERROR