Re: H/W RAID 5 on slower disks versus no raid on faster HDDs

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: H/W RAID 5 on slower disks versus no raid on faster HDDs
Date: 2002-11-21 17:46:55
Message-ID: 200211212316.55081.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Oh i did not mention,
its linux, it does.

RAM: 2.0 GB
CPU: Dual 2.0 Ghz Intel Xeon DP Processors.

On Thursday 21 November 2002 23:02, scott.marlowe wrote:
> On Thu, 21 Nov 2002, Rajesh Kumar Mallah. wrote:
> > Hi folks,
> >
> > I have two options:
> > 3*18 GB 10,000 RPM Ultra160 Dual Channel SCSI controller + H/W Raid 5
> > and
> > 2*36 GB 15,000 RPM Ultra320 Dual Channel SCSI and no RAID
> >
> > Does anyone opinions *performance wise* the pros and cons of above
> > two options.
> >
> > please take in consideration in latter case its higher RPM and better
> > SCSI interface.
>
> Does the OS you're running on support software RAID? If so the dual 36
> gigs in a RAID0 software would be fastest, and in a RAID1 would still be
> pretty fast plus they would be redundant.

>
> Depending on your queries, there may not be a lot of difference between
> running the 3*18 hw RAID or the 2*36 setup, especially if most of your
> data can fit into memory on the server.
> Generally, the 2*36 should be faster for writing, and the 3*18 should be
> about even for reads, maybe a little faster.

Since i got lots of RAM and my Data Size (on disk ) is 2 GB i feel frequent reads
can happen from the memory.

I have heard putting pg_xlog in a drive of its own helps in boosting updates to
DB server.
in that case shud i forget abt the h/w and use one disk exclusively for the WAL?

Regds
mallah.

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-11-21 17:58:43 Re: H/W RAID 5 on slower disks versus no raid on faster HDDs
Previous Message scott.marlowe 2002-11-21 17:32:05 Re: H/W RAID 5 on slower disks versus no raid on faster

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-11-21 17:58:43 Re: H/W RAID 5 on slower disks versus no raid on faster HDDs
Previous Message scott.marlowe 2002-11-21 17:38:20 Re: Is there a system of cache in pgsql 7.3rc1 ?