Adaptecs RAID controllers as all underwhelming.
The best commodity RAID controllers in terms of performance, size of available BBC, connectivity technologies (all of
IDE,SCSI, SATA and FC are supported), etc are made by Areca.
Get one of Areca's RAID controllers that hold up to 2 GB of BBC.
ARC-11xx are the PCI-X based products.
ARC-12xx are the PCI-E based products.
Reviews at places like tweakers.net
Areca is based in Taiwan, but has European and US offices as well
Ron Peacetree
-----Original Message-----
>From: Kenji Morishige <kenjim@juniper.net>
>Sent: Jul 5, 2006 7:46 PM
>To: pgsql-performance@postgresql.org
>Cc: kenjim@juniper.net
>Subject: [PERFORM] suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
>
>I am currently running FreeBSD 4.11 (due to IT requirements for now) and
>Adaptec's 2200S RAID controller running in RAID5. I was advised in the past
>that the 2200S is actually a poor performing controller and obviously the
>RAID5 is less than ideal for databases. I chose to run the controller in
>RAID5 as the tech I talked to suggested that the 2200S was primarily designed
>for RAID5 and it would operate the best that way. My server is a dual Xeon
> 3.06Ghz box running on a motherboard approximately 2-3 years old now. I'd
>like to know what an ideal RAID controller that would be compatible with
>FreeBSD 6.1 would be these days.
>
>Thanks in advance,
>Kenji
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match