Re: [Testperf-general] dbt2 & opteron performance

On Fri, Jul 29, 2005 at 12:51:57PM -0700, Mark Wong wrote:
> > Not sure I fully understand what you're trying to say, but it seems like
> > it might still be worth trying my original idea of just turning all 80
> > disks into one giant RAID0/striped array and see how much more bandwidth
> > you get out of that. At a minimum it would allow you to utilize the
> > remaining spindles, which appear to be unused right now.
>
> I have done that before actually, when the tablespace patch came out. I
> was able to get almost 40% more throughput with half the drives than
> striping all the disks together.

Wow, that's a pretty stunning difference... any idea why?

I think it might be very useful to see some raw disk IO benchmarks...
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"