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" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
