X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A306FD953D for ; Sun, 25 Sep 2005 11:57:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48110-01 for ; Sun, 25 Sep 2005 14:57:51 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id DACACD956A for ; Sun, 25 Sep 2005 11:57:53 -0300 (ADT) Received: (qmail 8232 invoked from network); 25 Sep 2005 14:57:57 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.2?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 25 Sep 2005 14:57:57 -0000 In-Reply-To: <43367937.40809@canaan.co.il> References: <43367937.40809@canaan.co.il> Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: PFC , pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: Advice on RAID card Date: Sun, 25 Sep 2005 10:57:56 -0400 To: Michael Ben-Nes X-Mailer: Apple Mail (2.734) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.02 required=5 tests=[AWL=0.020] X-Spam-Level: X-Archive-Number: 200509/330 X-Sequence-Number: 14638 I would think software raid would be quite inappropriate considering postgres when it is working is taking a fair amount of CPU as would software RAID. Does anyone know if this is really the case ? Dave On 25-Sep-05, at 6:17 AM, Michael Ben-Nes wrote: > I would consider Software Raid > > > PFC wrote: > > >> >> Hello fellow Postgresql'ers. >> >> I've been stumbled on this RAID card which looks nice. It is a >> PCI-X SATA Raid card with 6 channels, and does RAID 0,1,5,10,50. >> It is a HP card with an Adaptec chip on it, and 64 MB cache. >> >> HP Part # : 372953-B21 >> Adaptec Part # : AAR-2610SA/64MB/HP >> >> There' even a picture : >> http://megbytes.free.fr/Sata/DSC05970.JPG >> >> I know it isn't as good as a full SCSI system. I just want to >> know if some of you have had experiences with these, and if this >> cards belong to the "slower than no RAID" camp, like some DELL >> card we often see mentioned here, or to the "decent performance >> for the price" camp. It is to run on a Linux. >> >> Thanks in advance for your time and information. >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 4: Have you searched our list archives? >> >> http://archives.postgresql.org >> > > > -- > -------------------------- > Canaan Surfing Ltd. > Internet Service Providers > Ben-Nes Michael - Manager > Tel: 972-4-6991122 > Cel: 972-52-8555757 > Fax: 972-4-6990098 > http://www.canaan.net.il > -------------------------- > > > ---------------------------(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 > >