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

Re: recommended benchmarks

From: "Bucky Jordan" <bjordan(at)lumeta(dot)com>
To: "Brad Nicholson" <bnichols(at)ca(dot)afilias(dot)info>,"Charles Sprickman" <spork(at)bway(dot)net>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: recommended benchmarks
Date: 2006-09-22 21:18:24
Message-ID: 78ED28FACE63744386D68D8A9D1CF5D4209A96@MAIL.corp.lumeta.com (view raw or flat)
Thread:
Lists: pgsql-performance
> On Fri, 2006-09-22 at 13:14 -0400, Charles Sprickman wrote:
> > Hi all,
> >
> > I still have an dual dual-core opteron box with a 3Ware 9550SX-12
> sitting
> > here and I need to start getting it ready for production.  I also
have
> to
> > send back one processor since we were mistakenly sent two. Before I
do
> > that, I would like to record some stats for posterity and post to
the
> list
> > so that others can see how this particular hardware performs.
> >
> > It looks to be more than adequate for our needs...
> >
> > What are the standard benchmarks that people here use for comparison
> > purposes?  I know all benchmarks are flawed in some way, but I'd at
> least
> > like to measure with the same tools that folks here generally use to
get
> a
> > ballpark figure.
> 
> Check out the OSDL stuff.
> 
>
http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_sui
te
> /
> 
> Brad.
> 

Let me know what tests you end up using and how difficult they are to
setup/run- I have a dell 2950 (2 dual core woodcrest) that I could
probably run the same tests on. I'm looking into DBT2 (OLTP, similar to
TPC-C) to start with, then probably DBT-3 since it's more OLAP style
(and more like the application I'll be dealing with). 

What specific hardware are you testing? (CPU, RAM, raid setup, etc?)

- Bucky

In response to

Responses

pgsql-performance by date

Next:From: Alex TurnerDate: 2006-09-22 21:38:23
Subject: Re: Confusion and Questions about blocks read
Previous:From: Cosimo StrepponeDate: 2006-09-22 20:48:16
Subject: Re: Update on high concurrency OLTP application and Postgres

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