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

Re: Yet another open-source benchmark

From: Neil Conway <neilc(at)samurai(dot)com>
To: cbbrowne(at)cbbrowne(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Yet another open-source benchmark
Date: 2003-03-03 20:29:55
Message-ID: 1046723395.7912.10.camel@tokyo (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 2003-03-03 at 07:41, cbbrowne(at)cbbrowne(dot)com wrote:
> > (In fact, they seem to think they are testing kernel performance, not
> > database performance, which strikes me as rather bizarre.  But anyway.)
> 
> That may be a terminology thing; the main SAP-DB process is called the 
> "kernel," and it's more than likely that the "SAP-DB Kernel" is the sense in 
> which the term is being used.

Actually, I believe the reason the benchmark was developed was to
provide a workload for optimizing high-end Linux kernel performance
(with the inference being that SAP-DB is pretty close to Oracle, Oracle
performance is important for enterprise deployment of Linux, and
therefore optimizing the kernel's handling of SAP-DB running TPC
benchmarks will tend to improve the kernel's performance running
Oracle/DB2/etc.) So when they mean "kernel", I think they really mean
"kernel".

That's not to say that the benchmark wouldn't be useful for doing other
stuff, like pure database benchmarks (as long as its a valid
implementation of TPC-C (or TPC-H, etc.), it should be fine...)

A research group at the university I attend (www.queensu.ca) expressed
some interested in a TPC-C implementation for PostgreSQL, so I was
planning to port the OSDL TPC-C implementation to PostgreSQL.
Unfortunately, I got sidetracked for a couple reasons: (1) lack of time
(2) increasing awareness of just how boring writing benchmark apps is
:-) (3) distaste for ODBC. While I'd like to get some time to do the
port in the future, that shouldn't stop anyone else from doing so in the
mean time :-)

Cheers,

Neil
-- 
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC




In response to

Responses

pgsql-hackers by date

Next:From: Merlin MoncureDate: 2003-03-03 20:47:21
Subject: FW: [PATCHES] XML ouput for psql
Previous:From: Brandon Craig RhodesDate: 2003-03-03 19:43:30
Subject: bug? rules fail to cascade after NOT IN

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