Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DA211650014 for ; Mon, 24 Nov 2008 12:24:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53538-02 for ; Mon, 24 Nov 2008 12:24:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.175]) by mail.postgresql.org (Postfix) with ESMTP id 27BAF64FF27 for ; Mon, 24 Nov 2008 12:24:11 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 25so2176402wfc.28 for ; Mon, 24 Nov 2008 08:24:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=k9eQEmoM8GGOm2N1S6JibA5x3P2/hO9MYZqHBrfx5io=; b=WNO32Wf5lzdbM0YgDVgIm0EOd3f/1XLNQkQ6Kdnvz6C87bfQvHLCPNQaVeFGvky1xG tr1R45hKiYKOYLywU0XeOuV1VasMgueDpGjIWmnkQvmgFZXufrXMMxZtzuKGR+6cENUJ 6OOtn71AzKSQbqEkAGPUiQfxpIx39Y2sEhSFc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=v6wAjdpuDsGI2AsqG8IY5LuDa1lHUTt3FJvJmZwov7Mh7XlxEwzrIxQ0LM/zkxWMjl YAaRnJMykNibc84iZ8eppIOyoL3+8wWi6Qw+sRk7W3VzCesDwXtu7GjNgLYVclgerQeN x2tUXoQlADNgsnXPwMBLVjq6q/LhUbIQ6h7Yg= Received: by 10.140.162.20 with SMTP id k20mr1937337rve.218.1227543849444; Mon, 24 Nov 2008 08:24:09 -0800 (PST) Received: by 10.140.248.12 with HTTP; Mon, 24 Nov 2008 08:24:09 -0800 (PST) Message-ID: Date: Mon, 24 Nov 2008 09:24:09 -0700 From: "Scott Marlowe" To: "Simon Waters" Subject: Re: Perc 3 DC Cc: pgsql-performance@postgresql.org In-Reply-To: <200811241541.43542.simonw@zynet.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <911105.66836.qm@web23605.mail.ird.yahoo.com> <200811241541.43542.simonw@zynet.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/234 X-Sequence-Number: 31965 On Mon, Nov 24, 2008 at 8:41 AM, Simon Waters wrote: > That said a couple of weeks back ours corrupted a volume on replacing a dead > hard disk, so I'm never touching these cheap and tacky LSI RAID cards ever > again. It is suppose to just start rebuilding the array when you insert the > replacement drive, if it doesn't "just work" schedule some down time and > figure out exactly why, don't (for example) blindly follow the instructions > in the manual on what to do if it doesn't "just work". Reminds me of a horror story at a company I was at some years ago. Another group was running Oracle on a nice little 4 way Xeon with a Gig of ram (back when they was a monster server) and had an LSI card. They unplugged the server to move it into the hosting center, and in the move, the scsi cable came loose. When the machine came up, the LSI RAID marked every drive bad and the old 4xx series card had no facility for forcing it to take back a drive. All their work on the db was gone, newest backup was months old. I'm pretty sure they now understand why RAID5 is no replacement for a good backup plan. I had a 438 in a dual ppro200, and it worked just fine, but I never trusted it to auto rebuild anything, and made backups every night. It was slow (in the 30 meg/second reads on a 6 disk RAID 5, not faster in RAID-10 for reads or writes) but reliable. Newer LSI cards seem quite nice, but I'm now using an Areca 16xx series and am so far very happy with it's reliability and somewhat happy with its performance. Sequential read speed is meh, but random performance is very good, so for a db server, it's a nice unit.