X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C9527D8F06 for ; Wed, 14 Sep 2005 17:40:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38093-08 for ; Wed, 14 Sep 2005 20:40:26 +0000 (GMT) Received: from ionian.i-clic.uihc.uiowa.edu (ionian.i-clic.uihc.uiowa.edu [129.255.211.20]) by svr1.postgresql.org (Postfix) with ESMTP id 7EC7CD8F05 for ; Wed, 14 Sep 2005 17:40:26 -0300 (ADT) Received: by ionian.i-clic.uihc.uiowa.edu (Postfix, from userid 76) id F172361DAE; Wed, 14 Sep 2005 14:30:07 -0500 (CDT) Received: from [209.101.126.78] (unknown [209.101.126.78]) by ionian.i-clic.uihc.uiowa.edu (Postfix) with ESMTP id A36FE61DAD; Wed, 14 Sep 2005 14:30:06 -0500 (CDT) Message-ID: <43288AB9.4000204@arbash-meinel.com> Date: Wed, 14 Sep 2005 16:40:25 -0400 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alvaro Herrera Cc: "Jeffrey W. Baker" , Peter Darley , Pgsql-Performance Subject: Re: Battery Backed Cache for RAID References: <1126722523.27650.6.camel@toonses.gghcwest.com> <20050914200324.GB26714@surnet.cl> In-Reply-To: <20050914200324.GB26714@surnet.cl> X-Enigmail-Version: 0.92.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigCB24377D1936EBF5BE704C07" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.012 required=5 tests=[AWL=0.012] X-Spam-Level: X-Archive-Number: 200509/194 X-Sequence-Number: 14502 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigCB24377D1936EBF5BE704C07 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Alvaro Herrera wrote: > On Wed, Sep 14, 2005 at 11:28:43AM -0700, Jeffrey W. Baker wrote: > >>On Wed, 2005-09-14 at 11:25 -0700, Peter Darley wrote: >> >>> I'm getting a new server for our database, and I have a quick question >>>about RAID controllers with a battery backed cache. I understand that the >>>cache will allow the cache to be written out if the power fails to the box, >>>which allows it to report a write as committed safely when it's not actually >>>committed. >> >>Actually the cache will just hold its contents while the power is out. >>When the power is restored, the RAID controller will complete the writes >>to disk. If the battery does not last through the outage, the data is >>lost. > > > Just curious: how long are the batteries supposed to last? > The recent *cheap* version of a ramdisk had battery backup for 16 hours. (Very expensive ramdisks actually have enough battery power to power a small hard-drive to dump the contents into). I'm guessing for a RAID controller, the time would be in the max 1 day range. John =:-> --------------enigCB24377D1936EBF5BE704C07 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (Darwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDKIq5JdeBCYSNAAMRAq1FAKCmgrBueViWwac9+x7QgA5ANHsrRwCfZ0ZS 440kj2BgXv8wwVDzTjCjlwc= =zCG9 -----END PGP SIGNATURE----- --------------enigCB24377D1936EBF5BE704C07--