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 1AC94329D41 for ; Thu, 16 Sep 2004 19:10:24 +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 22820-02 for ; Thu, 16 Sep 2004 18:10:14 +0000 (GMT) Received: from omnis-mail.omnis.com (omnis-mail.omnis.com [216.239.128.28]) by svr1.postgresql.org (Postfix) with ESMTP id 16E32329C67 for ; Thu, 16 Sep 2004 19:10:14 +0100 (BST) Received: from [216.239.128.141] (daniel.omnis.com [216.239.128.141]) by omnis-mail.omnis.com (Postfix) with ESMTP id E68981BD16; Thu, 16 Sep 2004 11:10:13 -0700 (PDT) Message-ID: <4149D705.7050900@omnis.com> Date: Thu, 16 Sep 2004 11:10:13 -0700 From: Daniel Ceregatti Organization: Omnis Network User-Agent: Mozilla Thunderbird 0.7.1 (X11/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Cc: ricardo@sqlmagazine.com.br Subject: Re: Article about PostgreSQL and RAID in Brazil References: <200409161050.33289.josh@agliodbs.com> In-Reply-To: <200409161050.33289.josh@agliodbs.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/169 X-Sequence-Number: 8297 >The first part of the article can be found in >http://www.sqlmagazine.com.br/colunistas.asp?artigo=Colunistas/RicardoRezende/06_Raid_P1.asp > > The site seems to be down. I was looking forward to reading it. :( >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 >because of the risk of data corruption after a power failure. > > Here is a small example of the performance difference with write cache: http://sh.nu/bonnie.txt -- Daniel Ceregatti - Programmer Omnis Network, LLC A little suffering is good for the soul. -- Kirk, "The Corbomite Maneuver", stardate 1514.0