Re: my boss want to migrate to ORACLE - Mailing list pgsql-performance

From Stephane Tessier
Subject Re: my boss want to migrate to ORACLE
Date
Msg-id 004c01c478d7$fd8944f0$4e00020a@develavoie
Whole thread Raw
In response to Re: my boss want to migrate to ORACLE  (James Thornton <james@jamesthornton.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: James Thornton
Date:
Subject: Re: my boss want to migrate to ORACLE
Next
From: Gaetano Mendola
Date:
Subject: Re: Page Miss Hits