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 425B09FB1C2 for ; Fri, 7 Jul 2006 10:57:59 -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 60449-08 for ; Fri, 7 Jul 2006 10:57:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 116D69FB1B9 for ; Fri, 7 Jul 2006 10:57:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from elasmtp-mealy.atl.sa.earthlink.net (elasmtp-mealy.atl.sa.earthlink.net [209.86.89.69]) by svr4.postgresql.org (Postfix) with ESMTP id 1CDDC5AF06D for ; Fri, 7 Jul 2006 13:57:55 +0000 (GMT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=dx4jPI7Wum/l2H1R2BdvRmJPc9ZbZu3In5VW33QQsOgqV9iG+eM/QCRpD/hLq+55; h=Message-ID:Date:From:Reply-To:To:Subject:Mime-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:X-ELNK-Trace:X-Originating-IP; Received: from [209.86.224.42] (helo=elwamui-muscovy.atl.sa.earthlink.net) by elasmtp-mealy.atl.sa.earthlink.net with asmtp (Exim 4.34) id 1Fyqq9-0003qU-VW for pgsql-performance@postgresql.org; Fri, 07 Jul 2006 09:57:54 -0400 Received: from 71.243.53.95 by webmail.pas.earthlink.net with HTTP; Fri, 7 Jul 2006 09:57:53 -0400 Message-ID: <10119704.1152280673965.JavaMail.root@elwamui-muscovy.atl.sa.earthlink.net> Date: Fri, 7 Jul 2006 09:57:53 -0400 (EDT) From: Ron Peacetree Reply-To: Ron Peacetree To: pgsql-performance@postgresql.org Subject: Re: suggested RAID controller for FreeBSD 6.1 + Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: EarthLink Zoo Mail 1.0 X-ELNK-Trace: acd68a6551193be5d780f4a490ca69563f9fea00a6dd62bcefa875c36c6f036cd72932127e40f68f350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 209.86.224.42 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/66 X-Sequence-Number: 19926 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 >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