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.
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 |
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 ? |