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 46554D1B184 for ; Mon, 2 Aug 2004 18:30:58 -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 31678-04 for ; Mon, 2 Aug 2004 21:30:55 +0000 (GMT) Received: from asdc003.abovesecurite.lan (unknown [206.162.148.235]) by svr1.postgresql.org (Postfix) with ESMTP id 6E288D1B18C for ; Mon, 2 Aug 2004 18:30:51 -0300 (ADT) Received: from develavoie ([206.162.148.230]) by asdc003.abovesecurite.lan over TLS secured channel with Microsoft SMTPSVC(6.0.3790.0); Mon, 2 Aug 2004 17:35:59 -0400 From: "Stephane Tessier" To: "'James Thornton'" Cc: "'Scott Marlowe'" , , Subject: Re: my boss want to migrate to ORACLE Date: Mon, 2 Aug 2004 17:30:52 -0400 Message-ID: <004c01c478d7$fd8944f0$4e00020a@develavoie> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <410EB2E3.6040609@jamesthornton.com> Importance: Normal x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1409 X-OriginalArrivalTime: 02 Aug 2004 21:35:59.0265 (UTC) FILETIME=[B37AB910:01C478D8] 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: 200408/22 X-Sequence-Number: 7658 oups, i changed for RAID 10(strip and mirror).... -----Original Message----- From: James Thornton [mailto:james@jamesthornton.com] Sent: 2 aout, 2004 17:32 To: Stephane Tessier Cc: 'Scott Marlowe'; markir@coretech.co.nz; pgsql-performance@postgresql.org Subject: Re: [PERFORM] my boss want to migrate to ORACLE 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