X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8EABD329E39 for ; Fri, 17 Sep 2004 00:00:26 +0100 (BST) 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 25620-05 for ; Thu, 16 Sep 2004 23:00:22 +0000 (GMT) Received: from mail0.rawbw.com (mail0.rawbw.com [198.144.192.41]) by svr1.postgresql.org (Postfix) with ESMTP id 6768B329E23 for ; Fri, 17 Sep 2004 00:00:23 +0100 (BST) Received: (from www@localhost) by mail0.rawbw.com (8.11.6p2/8.11.6) id i8GN0Jo27977; Thu, 16 Sep 2004 16:00:19 -0700 (PDT) Received: from cybs-gw.ic3.com (cybs-gw.ic3.com [66.185.177.10]) by webmail.rawbw.com (IMP) with HTTP for ; Thu, 16 Sep 2004 16:00:19 -0700 Message-ID: <1095375619.414a1b034ba63@webmail.rawbw.com> Date: Thu, 16 Sep 2004 16:00:19 -0700 From: mudfoot@rawbw.com To: josh@agliodbs.com Cc: pgsql-performance@postgresql.org Subject: Re: Article about PostgreSQL and RAID in Brazil References: <200409161050.33289.josh@agliodbs.com> In-Reply-To: <200409161050.33289.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 66.185.177.10 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200409/183 X-Sequence-Number: 8311 Quoting Josh Berkus : > The first and most important step for RAID performance with PostgreSQL is to > > get a card with onboard battery back-up and enable the write cache for the > card. You do not want to enable the write cache *without* battery back-up > I'm curious about this -- how do you avoid losing data if a cache stick dies? Without redundancy, whatever hasn't been destaged to the physical media vanishes Dual-controller external arrays (HDS, EMC, LSI, etc.) tend to mirror (though algorithms vary) the cache in addition to battery backup. But do onboard arrays tend to do this as well? Mark