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

From James Thornton
Subject Re: my boss want to migrate to ORACLE
Date
Msg-id 410EB2E3.6040609@jamesthornton.com
Whole thread Raw
In response to Re: my boss want to migrate to ORACLE  ("Stephane Tessier" <stephane.tessier@abovesecurity.com>)
Responses Re: my boss want to migrate to ORACLE
List pgsql-performance
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: Rod Taylor
Date:
Subject: Re: Page Miss Hits
Next
From: "Stephane Tessier"
Date:
Subject: Re: my boss want to migrate to ORACLE