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

Re: recommended benchmarks

From: "Denis Lussier" <denisl(at)enterprisedb(dot)com>
To: "Bucky Jordan" <bjordan(at)lumeta(dot)com>
Cc: "Brad Nicholson" <bnichols(at)ca(dot)afilias(dot)info>, "Charles Sprickman" <spork(at)bway(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: recommended benchmarks
Date: 2006-09-23 11:52:48
Message-ID: 5f820f750609230452j2a0c736vecc489757ed1b36c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
If the real world applications you'll be running on the box are Java
(or use lots of prepared statements and no stored procedures)...   try
BenchmarkSQL from pgFoundry.  Its extremely easy to setup and use.
Like the DBT2, it's an oltp benchmark that is similar to the tpc-c.

--Denis Lussier
 http://www.enterprisedb.com

On 9/22/06, Bucky Jordan <bjordan(at)lumeta(dot)com> wrote:
> > 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

In response to

pgsql-performance by date

Next:From: Markus SchaberDate: 2006-09-23 12:19:42
Subject: Re: Confusion and Questions about blocks read
Previous:From: Anthony PresleyDate: 2006-09-23 00:25:24
Subject: Re: Why is it choosing a different plan?

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