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

Re: Yet another open-source benchmark

From: Mark Wong <markw(at)osdl(dot)org>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: cbbrowne(at)cbbrowne(dot)com, 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 21:20:26
Message-ID: 1046726426.11210.28.camel@ibm-b (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 2003-03-03 at 12:29, Neil Conway wrote:
> 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".

Yeah, Neil more-or-less hit it on the nose.  The SAP DB folks do refer
to their processes as kernel processes, but our focus is on the Linux
kernel and helping Linux gain more ground for the enterprise.
 
> 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 :-)

And we're prepared to aid any effort. :)
 
> Cheers,
> 
> Neil
> -- 
> Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
Mark Wong - - markw(at)osdl(dot)org
Open Source Development Lab Inc - A non-profit corporation
15275 SW Koll Parkway - Suite H - Beaverton OR, 97006
(503)-626-2455 x 32 (office)
(503)-626-2436      (fax)
http://www.osdl.org/archive/markw/


In response to

pgsql-hackers by date

Next:From: Greg CopelandDate: 2003-03-03 21:54:50
Subject: Re: [HACKERS] Postgresql performace question
Previous:From: Merlin MoncureDate: 2003-03-03 20:47:21
Subject: FW: [PATCHES] XML ouput for psql

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