Re: [PERFORM] RAID stripe size question

2006-07-16 Thread Alex Turner
With 18 disks dedicated to  data, you could make 100/7*9 seeks/second (7ms av seeks time, 9 independant units) which is 128seeks/second writing on average 64kb of data, which is 4.1MB/sec throughput worst case, probably 10x best case so 40Mb/sec - you might want to take more disks for your data and

Re: [PERFORM] RAID stripe size question

2006-07-16 Thread Michael Stone
On Mon, Jul 17, 2006 at 12:52:17AM +0200, Mikael Carneholm wrote: I have finally gotten my hands on the MSA1500 that we ordered some time ago. It has 28 x 10K 146Gb drives, currently grouped as 10 (for wal) + 18 (for data). There's only one controller (an emulex), but I hope You've got 1.4TB as

Re: [PERFORM] RAID stripe size question

2006-07-16 Thread Steinar H. Gunderson
On Mon, Jul 17, 2006 at 12:52:17AM +0200, Mikael Carneholm wrote: > Now to the interesting part: would it make sense to use different stripe > sizes on the separate disk arrays? In theory, a smaller stripe size > (8-32K) should increase sequential write throughput at the cost of > decreased positio

[PERFORM] RAID stripe size question

2006-07-16 Thread Mikael Carneholm
Title: RAID stripe size question I have finally gotten my hands on the MSA1500 that we ordered some time ago. It has 28 x 10K 146Gb drives, currently grouped as 10 (for wal) + 18 (for data). There's only one controller (an emulex), but I hope performance won't suffer too much from that. Raid

Re: [PERFORM] Big differences in plans between 8.0 and 8.1

2006-07-16 Thread Joe Conway
Gabriele Turchi wrote: Il giorno sab, 15/07/2006 alle 13.04 -0700, Joe Conway ha scritto: Why not just periodically (once an hour?) run "ANALYZE registrazioni;" during the day. This will only update the statistics, and should be very low impact. This is my "solution" too... but: is enough? Or