| From: | James Thornton <james(at)jamesthornton(dot)com> |
|---|---|
| To: | Stephane Tessier <stephane(dot)tessier(at)abovesecurity(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:32:19 |
| Message-ID: | 410EB2E3.6040609@jamesthornton.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2004-08-02 22:13:56 | Re: Page Miss Hits |
| Previous Message | Stephane Tessier | 2004-08-02 21:30:52 | Re: my boss want to migrate to ORACLE |