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 C083DD1B171 for ; Mon, 2 Aug 2004 18:27:57 -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 30869-03 for ; Mon, 2 Aug 2004 21:27:54 +0000 (GMT) Received: from roam.unifiedmind.com (unifiedmind.com [209.164.72.58]) by svr1.postgresql.org (Postfix) with SMTP id 04CEBD1B1EC for ; Mon, 2 Aug 2004 18:27:50 -0300 (ADT) Received: (qmail 12194 invoked from network); 2 Aug 2004 21:57:29 -0000 Received: from unknown (HELO jamesthornton.com) (james@24.175.14.24) by 0 with SMTP; 2 Aug 2004 21:57:29 -0000 Message-ID: <410EB2E3.6040609@jamesthornton.com> Date: Mon, 02 Aug 2004 16:32:19 -0500 From: James Thornton User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stephane Tessier Cc: 'Scott Marlowe' , markir@coretech.co.nz, pgsql-performance@postgresql.org Subject: Re: my boss want to migrate to ORACLE References: <004b01c478d6$47f46530$4e00020a@develavoie> In-Reply-To: <004b01c478d6$47f46530$4e00020a@develavoie> 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.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200408/21 X-Sequence-Number: 7657 Stephane Tessier wrote: > I checked and we have a 128 megs battery backed cache on the raid > controller... >>we have space for more ram(we use 2 gigs on possibility of 3 gigs) >>iowait is very high 98% --> look like postgresql wait for io access >>raid5 -->raid0 if i'm right raid5 use 4 writes(parity,data, etc) for each >>write on disk > > Just get battery backed cache on your RAID controller. RAID0 is way too > unreliable for a production environment. One disk dies and all your > data is just gone. I'm the one who sent the e-mail about RAID 5's 4 writes, but I suggested you look at RAID 10, not RAID 0. -- James Thornton ______________________________________________________ Internet Business Consultant, http://jamesthornton.com