Re: RAID Stripe size - Mailing list pgsql-performance

From evgeny gridasov
Subject Re: RAID Stripe size
Date
Msg-id 20050920145307.1a111595.eugrid@fpm.kubsu.ru
Whole thread Raw
In response to RAID Stripe size  ("bm\\mbn" <miki@canaan.co.il>)
Responses Re: RAID Stripe size  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
Hi Everybody!

I've got a spare machine which is 2xXEON 3.2GHz, 4Gb RAM
14x140Gb SCSI 10k (LSI MegaRaid 320U). It is going into production in 3-5months.
I do have free time to run tests on this machine, and I could test different stripe sizes
if somebody prepares a test script and data for that.

I could also test different RAID modes 0,1,5 and 10 for this script.

I guess the community needs these results.

On 16 Sep 2005 04:51:43 -0700
"bm\\mbn" <miki@canaan.co.il> wrote:

> Hi Everyone
>
> The machine is IBM x345 with ServeRAID 6i 128mb cache and 6 SCSI 15k
> disks.
>
> 2 disks are in RAID1 and hold the OS, SWAP & pg_xlog
> 4 disks are in RAID10 and hold the Cluster itself.
>
> the DB will have two major tables 1 with 10 million rows and one with
> 100 million rows.
> All the activities against this tables will be SELECT.
>
> Currently the strip size is 8k. I read in many place this is a poor
> setting.
>
> Am i right ?

--
Evgeny Gridasov
Software Developer
I-Free, Russia

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: RAID Stripe size
Next
From: Richard Woo
Date:
Subject: unsubscribe