dbt2 & opteron performance - Mailing list pgsql-hackers

From Mark Wong
Subject dbt2 & opteron performance
Date
Msg-id 200507121947.j6CJlEjA026239@smtp.osdl.org
Whole thread Raw
Responses Re: [Testperf-general] dbt2 & opteron performance  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
I'm starting to get results with dbt2 on a 4-way opteron system and
wanted to share what I've got so far since people have told me in the
past that this architecture is more interesting than the itanium2 that
I've been using.

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

Results for a 600 warehouse run are there:http://www.osdl.org/projects/dbt2dev/results/dev4-015/6/

The tuning is a still a bit off, but feel free to let me know if there
are any issues anyway.

Mark


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: PL/Perl list value return causes segfault
Next
From: Marko Kreen
Date:
Subject: Re: 4 pgcrypto regressions failures - 1 unsolved