Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BB49D632BD2 for ; Tue, 2 Mar 2010 23:27:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18016-08 for ; Wed, 3 Mar 2010 03:26:59 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 1CD5B632789 for ; Tue, 2 Mar 2010 23:26:59 -0400 (AST) Received: by wya21 with SMTP id 21so538563wya.19 for ; Tue, 02 Mar 2010 19:26:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=QjEH84rMTTgcC338SdHhurVYbMxMI2++oJotQgGgbvs=; b=C/Ew0XpZ1U6jrY1+R5wECxuLoCt3Yy4+WA9O0/cXOjp6SnDM3GbGbSW8xO+6Js9NUt Alrvo42VSP6+EWX7+hMj6FjmjLyDC/Tu6gcr6zzV2NaVXrg8ImfXXT4cEJ9ZtHnoyELt Btc+pVRV1Uos1m4hqNc4ID/bpEQNZfumA3Cg8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=nu1fIN2Iw2s5Pv+40n1tm9sy7thDimwXL8hfIvuivAaTCPa/eAcmTPa/C/aiezzw0W zIVoNX94fIbfd8e3LXsRKcs98j1twuA9CuKKLlhSrrsMn2DH0xueZcSsnOYI/v96H794 WD9u/ipafPjIiEqb5QlXQzCFHXdNFJFMHXZBI= MIME-Version: 1.0 Received: by 10.216.86.7 with SMTP id v7mr3433566wee.137.1267586818062; Tue, 02 Mar 2010 19:26:58 -0800 (PST) In-Reply-To: References: <4B8D7A6C.3010304@gmail.com> <4B8DA2D4.8000501@2ndquadrant.com> Date: Tue, 2 Mar 2010 20:26:58 -0700 Message-ID: Subject: Re: 10K vs 15k rpm for analytics From: Scott Marlowe To: Francisco Reyes Cc: Greg Smith , Yeb Havinga , Pgsql performance Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5 tests=BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201003/52 X-Sequence-Number: 37877 On Tue, Mar 2, 2010 at 7:44 PM, Francisco Reyes wr= ote: > Greg Smith writes: > >> http://www.3ware.com/KB/Article.aspx?id=3D15383 =A0I consider them still= a >> useful vendor for SATA controllers, but would never buy a SAS solution f= rom >> them again until this is resolved. > > > Who are you using for SAS? > One thing I like about 3ware is their management utility works under both > FreeBSD and Linux well. The non-open source nature of the command line tool for Areca makes me avoid their older cards. The 1680 has it's own ethernet wtih a web interface with snmp that is independent of the OS. This means that with something like a hung / panicked kernel, you can still check out the RAID array and check rebuild status and other stuff. We get a hang about every 180 to 460 days with them where the raid driver in linux hangs with the array going off-line. It's still there to the web interface on its own NIC. Newer kernels seem to trigger the failure far more often, once every 1 to 2 weeks, two months on the outside. The driver guy from Areca is supposed to be working on the driver for linux, so we'll see if it gets fixed. It's pretty stable on a RHEL 5.2 kernel, on anything after that I've tested, it'll hang every week or two. So I run RHEL 5.latest with a 5.2 kernel and it works pretty well. Note that this is a pretty heavily used machine with enough access going through 12 drives to use about 30% IOwait, 50% user, 10% sys at peak midday. Load factor 7 to 15. And they run really ultra-smooth between these hangs. They come back up uncorrupted, every time, every plug pull test etc. Other than the occasional rare hang, they're perfect.