X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8031DD1B472 for ; Mon, 26 Apr 2004 06:02:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38484-07 for ; Mon, 26 Apr 2004 06:01:59 -0300 (ADT) Received: from mail.dsvr.co.uk (mail.dsvr.co.uk [212.69.192.8]) by svr1.postgresql.org (Postfix) with ESMTP id 38A0CD1B46C for ; Mon, 26 Apr 2004 06:01:57 -0300 (ADT) Received: from [212.69.216.20] (helo=dsvr.net) by mail.dsvr.co.uk with esmtp (Exim 4.30) id 1BI1zy-0004CR-42 for pgsql-performance@postgresql.org; Mon, 26 Apr 2004 10:01:58 +0100 Message-ID: <408CD006.3090004@dsvr.net> Date: Mon, 26 Apr 2004 10:01:58 +0100 From: Rob Fielding User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8a) Gecko/20040418 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: OT: Help with performance problems References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/437 X-Sequence-Number: 6737 scott.marlowe wrote: > On Fri, 23 Apr 2004, Chris Hoover wrote: > > >>DB's on Powervaults 220S using raid 5 (over 6 disks) > > > What controller is this, the adaptec? We've found it to be slower than > the LSI megaraid based controller, but YMMV. Wow, really? You got any more details of the chipset, mobo and kernel driver ? I've been taken to my wits end wrestling with an LSI MegaRAID 320-1 controller on a supermicro board all weekend. I just couldn't get anything more than 10MB/sec out of it with megaraid driver v1 OR v2 in Linux 2.4.26, nor the version in 2.6.6-rc2. After 2 days of humming the Adaptec mantra I gave in and switched the array straight onto the onboard Adaptec 160 controller (same cable and everything). Software RAID 5 gets me over 40MB sec for a nominal cpu hit - more than 4 times what I could get out of the MegaRAID controller :( Even the 2nd SCSI-2 channel gets 40MB/sec max (pg_xlog :) And HOW LONG does it take to detect drives during POST....ohhhh never mind ... I really just wanna rant :) There should be a free counseling service for enraged sysops. -- Rob Fielding rob@dsvr.net www.dsvr.co.uk Development Designer Servers Ltd