From owner-freebsd-performance@FreeBSD.ORG Thu Nov 25 11:10:35 2010 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 944AE1065674 for ; Thu, 25 Nov 2010 11:10:35 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mx1.freebsd.org (Postfix) with ESMTP id 477B38FC16 for ; Thu, 25 Nov 2010 11:10:34 +0000 (UTC) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1PLZii-0004vA-Rl for freebsd-performance@freebsd.org; Thu, 25 Nov 2010 12:10:32 +0100 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 25 Nov 2010 12:10:32 +0100 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 25 Nov 2010 12:10:32 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Ivan Voras Date: Thu, 25 Nov 2010 12:10:28 +0100 Lines: 19 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.9.2.12) Gecko/20101102 Thunderbird/3.1.6 In-Reply-To: X-Enigmail-Version: 1.1.2 Subject: Re: Poor RAID performance demystified X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 25 Nov 2010 11:10:35 -0000 On 11/25/10 10:20, Yar Tikhiy wrote: > If you > still need greater write performance on tiny transactions, consider > getting a battery backup unit (BBU) for your RAID adapter. Quite > remarkably, HP refer to them as "Write-back Cache Enablers" because > installing one is the only way to get an HP RAID adapter do write-back > caching. A write-back cache with BBU will let the adapter delay and > coalesce tiny writes without jeopardizing the DB integrity. However, > you'll need to trust your BBU as your DB integrity will be staked on > it (the PG folks are somehow skeptical about BBUs). HP also has (and so do probably others by now) capacitor-backed flash caches; the theory is to have a fast random IO chunk of flash memory and use the capacitor to keep the power up for as long as the flash needs to write its large blocks. I've tried it and the performance is good, but don't have it in production yet.