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(at)canaan(dot)co(dot)il> wrote:
> Hi Everyone
> The machine is IBM x345 with ServeRAID 6i 128mb cache and 6 SCSI 15k
> 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
> Am i right ?
In response to
pgsql-performance by date
|Next:||From: Richard Woo||Date: 2005-09-20 13:50:24|
|Previous:||From: Michael Stone||Date: 2005-09-20 09:41:09|
|Subject: Re: RAID Stripe size|