Re: my boss want to migrate to ORACLE

From: "Stephane Tessier" <stephane(dot)tessier(at)abovesecurity(dot)com>
To: "'James Thornton'" <james(at)jamesthornton(dot)com>
Cc: "'Scott Marlowe'" <smarlowe(at)qwest(dot)net>, <markir(at)coretech(dot)co(dot)nz>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: my boss want to migrate to ORACLE
Date: 2004-08-02 21:30:52
Message-ID: 004c01c478d7$fd8944f0$4e00020a@develavoie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

oups,

i changed for RAID 10(strip and mirror)....

-----Original Message-----
From: James Thornton [mailto:james(at)jamesthornton(dot)com]
Sent: 2 aout, 2004 17:32
To: Stephane Tessier
Cc: 'Scott Marlowe'; markir(at)coretech(dot)co(dot)nz;
pgsql-performance(at)postgresql(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message James Thornton 2004-08-02 21:32:19 Re: my boss want to migrate to ORACLE
Previous Message Rod Taylor 2004-08-02 21:26:16 Re: Page Miss Hits