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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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