Re: dbt2 & opteron performance

Hi Mark,

Great stuff. One of the things that led me to PostgreSQL a couple years
back was the exceptional OLTP performance I was able to wring out of it
when running my own internal benchmarks against it.

I have a couple questions (that I apologize if they are answered
elsewhere). Note that the reason I ask is that I want to make sure we
are getting close to comparing apples to apples with how the commercial
companies "legally" run their tpc benchmarks.

1 - R we using 15,000 RPM SCSI drives mostly configured together as
RAID-0. Also what about write-ahead logging and background writing and
grouping transactions and ...

2 - I forget the brand off the top of my head, but, I don't think that
most commercial tpc tests use Adaptec controllers.

3 - R we yet testing with dual core Opterons (or at least two dual core
opterons)

It's perfectly reasonable if because of cost considerations the answer
is "not yet" to my questions above. For #1 above, a lot of people say
"but that's a bad idea...". To that I say yeah, but... it's the only
way to compare apples to apples when comparing Postgres to published
benchmarks commercial rdbms performance.

Please email me privately if there is some way EntepriseDB may be able
to help.

--Denis Lussier
Chief Architect and Chairman
EnterpriseDB Corporation

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)org] On Behalf Of Mark Wong
> Sent: Tuesday, July 12, 2005 3:47 PM
> To: pgsql-hackers(at)postgresql(dot)org; testperf-general(at)pgfoundry(dot)org
> Subject: [HACKERS] dbt2 & opteron performance
>
> 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
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: explain analyze is your friend