From: Denis Lussier <denisl@enterprisedb.com>
To: Bucky Jordan <bjordan@lumeta.com>
Cc: Brad Nicholson <bnichols@ca.afilias.info>
Cc: Charles Sprickman <spork@bway.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: recommended benchmarks
Date: Sat, 23 Sep 2006 07:52:48 -0400
Message-ID: <5f820f750609230452j2a0c736vecc489757ed1b36c@mail.gmail.com> (raw)
In-Reply-To: <78ED28FACE63744386D68D8A9D1CF5D4209A96@MAIL.corp.lumeta.com>
References: <1158952085.11550.0.camel@dba5.int.libertyrms.com>
<78ED28FACE63744386D68D8A9D1CF5D4209A96@MAIL.corp.lumeta.com>
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@lumeta.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: denisl@enterprisedb.com, bjordan@lumeta.com, bnichols@ca.afilias.info, spork@bway.net
Subject: Re: recommended benchmarks
In-Reply-To: <5f820f750609230452j2a0c736vecc489757ed1b36c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox