X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8B7049FA0EC for ; Thu, 6 Jul 2006 15:10:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 68938-09 for ; Thu, 6 Jul 2006 15:10:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from colo-dns-ext2.juniper.net (colo-dns-ext2.juniper.net [207.17.137.64]) by postgresql.org (Postfix) with ESMTP id B690B9F94F3 for ; Thu, 6 Jul 2006 15:10:32 -0300 (ADT) Received: from merlot.juniper.net (merlot.juniper.net [172.17.27.10]) by colo-dns-ext2.juniper.net (8.12.3/8.12.3) with ESMTP id k66IAT1Z017358; Thu, 6 Jul 2006 11:10:29 -0700 (PDT) (envelope-from kenjim@juniper.net) Received: from kenjim-lnx.juniper.net (kenjim-lnx.juniper.net [172.17.58.60]) by merlot.juniper.net (8.11.3/8.11.3) with ESMTP id k66IAT555281; Thu, 6 Jul 2006 11:10:29 -0700 (PDT) (envelope-from kenjim@juniper.net) Received: from kenjim-lnx.juniper.net (kenjim-lnx.juniper.net [127.0.0.1]) by kenjim-lnx.juniper.net (8.13.4/8.13.4) with ESMTP id k66IAOPm016297; Thu, 6 Jul 2006 11:10:24 -0700 Received: (from kenjim@localhost) by kenjim-lnx.juniper.net (8.13.4/8.13.4/Submit) id k66IAJH5016296; Thu, 6 Jul 2006 11:10:19 -0700 Date: Thu, 6 Jul 2006 11:10:19 -0700 From: Kenji Morishige To: Mark Kirkwood Cc: pgsql-performance@postgresql.org, kenjim@juniper.net Subject: Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Message-ID: <20060706181019.GA15855@juniper.net> References: <20060705234617.GB2367@juniper.net> <44AC5EB9.8060707@paradise.net.nz> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44AC5EB9.8060707@paradise.net.nz> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/51 X-Sequence-Number: 19911 Thanks for the suggestion Mark, though the server chassis I am trying to utilize already has 4 10,000 RPM SCSI drives with SCA interfaces. Ideally I would like to use the existing drives and chassis and find another SCSI RAID controller. It looks like 3Ware only makes ATA controllers. -Kenji On Thu, Jul 06, 2006 at 12:52:09PM +1200, Mark Kirkwood wrote: > Kenji Morishige wrote: > >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. > > > > > > I've had good experience with 3Ware on FreeBSD - painless installs and > excellent performance! (in my case the older 7506 models for (P)ATA on > 4.10, 5.4, 6.0 and 6.1). > > It looks like the new 9550 series is supported in 6.1 onwards. Given > that this has been added recently I would suggest mailing > freebsd-hardware to see what experiences folks are having (I don't > recall seeing any postings about issues with the 9000 or 9550 series). > > Cheers > > Mark