Re: [Testperf-general] dbt2 & opteron performance

From: Mark Wong <markw(at)osdl(dot)org>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, testperf-general(at)pgfoundry(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [Testperf-general] dbt2 & opteron performance
Date: 2005-07-28 23:15:31
Message-ID: 200507282314.j6SNErjA010778@smtp.osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 28 Jul 2005 17:17:25 -0500
"Jim C. Nasby" <decibel(at)decibel(dot)org> wrote:

> On Wed, Jul 27, 2005 at 07:32:34PM -0700, Josh Berkus wrote:
> > > This 4-way has 8GB of memory and four Adaptec 2200s controllers attached
> > > to 80 spindles (eight 10-disk arrays). For those familiar with the
> > > schema, here is a visual of the disk layout:
> > > http://www.osdl.org/projects/dbt2dev/results/dev4-015/layout-6.html
>
> Have you by-chance tried it with the logs and data just going to
> seperate RAID10s? I'm wondering if a large RAID10 would do a better job
> of spreading the load than segmenting things to specific drives.

No, haven't tried that. That would reduce my number of spindles as I
scale up. ;) I have the disks attached as JBODs and use LVM2 to stripe
the disks together.

Mark

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2005-07-28 23:16:01 Re: [Testperf-general] dbt2 & opteron performance
Previous Message Denis Lussier 2005-07-28 22:52:57 MySQL to PostgreSQL for SugarCRM