Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4A28CB5DC00 for ; Mon, 18 Jul 2011 04:56:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 25389-01 for ; Mon, 18 Jul 2011 07:56:39 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f46.google.com (mail-ew0-f46.google.com [209.85.215.46]) by mail.postgresql.org (Postfix) with ESMTP id 0C379B5DBFF for ; Mon, 18 Jul 2011 04:56:38 -0300 (ADT) Received: by ewy4 with SMTP id 4so1333522ewy.19 for ; Mon, 18 Jul 2011 00:56:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=nqK4e7ba0NnRmJvLC+mvY89HBOammMALzay2iq3BYn8=; b=Pl7sfmCknd9eAiE6laCvjSGINhbW0dkmwFrx45P/V5IiGF5mXyx/5dSxT93wsBWmJM Q2lyQulMNLlX4Lb+qUkPpmSiJR9Aam0hq3lUynawNmXyiohCuH3EpZwPfK22Q4aEgiak wEdlQxJoU8MaOY3M5+TLoxekOulKy2j4qTeyU= Received: by 10.213.31.197 with SMTP id z5mr1102631ebc.73.1310975797612; Mon, 18 Jul 2011 00:56:37 -0700 (PDT) Received: from [192.168.73.63] (5357DA75.cm-6-8d.dynamic.ziggo.nl [83.87.218.117]) by mx.google.com with ESMTPS id q16sm1969357eef.41.2011.07.18.00.56.35 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 18 Jul 2011 00:56:36 -0700 (PDT) Message-ID: <4E23E72B.2070508@gmail.com> Date: Mon, 18 Jul 2011 09:56:27 +0200 From: Yeb Havinga User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11 MIME-Version: 1.0 To: Andy CC: pgsql-performance@postgresql.org Subject: Re: BBU still needed with SSD? References: <1310953399.25726.YahooMailClassic@web111304.mail.gq1.yahoo.com> In-Reply-To: <1310953399.25726.YahooMailClassic@web111304.mail.gq1.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201107/173 X-Sequence-Number: 44385 On 2011-07-18 03:43, Andy wrote: > Hi, > > Is BBU still needed with SSD? > > SSD has its own cache. And in certain models such as Intel 320 that cache is backed by capacitors. So in a sense that cache acts as a BBU that's backed by capacitors instead of batteries. > > In this case is BBU still needed? If I put 2 SSD +with supercap? > in software RAID 1, would that be any slower than 2 SSD in HW RAID 1 with BBU? What are the pros and cons? The biggest drawback of 2 SSD's with supercap in hardware raid 1, is that if they are both new and of the same model/firmware, they'd probably reach the end of their write cycles at the same time, thereby failing simultaneously. You'd have to start with two SSD's with different remaining life left in the software raid setup. regards, Yeb