Skip site navigation (1) Skip section navigation (2)

Re: [Testperf-general] dbt2 & opteron performance

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Mark Wong <markw(at)osdl(dot)org>
Cc: testperf-general(at)pgfoundry(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [Testperf-general] dbt2 & opteron performance
Date: 2005-07-29 19:57:42
Message-ID: 20050729195742.GH95931@decibel.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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?"

In response to

Responses

pgsql-hackers by date

Next:From: Mark WongDate: 2005-07-29 20:11:35
Subject: Re: [Testperf-general] dbt2 & opteron performance
Previous:From: Mark WongDate: 2005-07-29 19:51:57
Subject: Re: [Testperf-general] dbt2 & opteron performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group