Re: [HACKERS] Yet another open-source benchmark

2003-03-03 Thread cbbrowne
 OSDL has just come out with a set of open-source database benchmarks:
 http://www.osdl.org/projects/performance/
 
 The bad news:
 This tool kit works with SAP DB open source database versions 7.3.0.23
 or 7.3.0.25.
 
 (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.

When they translate things from German, sometimes wordings change :-).
--
output = reverse(moc.enworbbc@ enworbbc)
http://www.ntlug.org/~cbbrowne/linuxxian.html
Rules  of the  Evil Overlord  #41. Once  my power  is secure,  I will
destroy all those pesky time-travel devices.
http://www.eviloverlord.com/



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


Re: [HACKERS] Yet another open-source benchmark

2003-03-03 Thread Tommi Maekitalo
On the results page they list kernels like linux-2.4.18-1tier or 
linux-2.4.19-rc2 or redhat-stock-2.4.7-10cmp. This sounds really like 
linux-kernel-versions.

Am Montag, 3. März 2003 13:41 schrieb [EMAIL PROTECTED]:
  OSDL has just come out with a set of open-source database benchmarks:
  http://www.osdl.org/projects/performance/
 
  The bad news:
  This tool kit works with SAP DB open source database versions 7.3.0.23
  or 7.3.0.25.
 
  (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.

 When they translate things from German, sometimes wordings change :-).
 --
 output = reverse(moc.enworbbc@ enworbbc)
 http://www.ntlug.org/~cbbrowne/linuxxian.html
 Rules  of the  Evil Overlord  #41. Once  my power  is secure,  I will
 destroy all those pesky time-travel devices.
 http://www.eviloverlord.com/



 ---(end of broadcast)---
 TIP 6: Have you searched our list archives?

 http://archives.postgresql.org

-- 
Dr. Eckhardt + Partner GmbH
http://www.epgmbh.de

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] Yet another open-source benchmark

2003-03-03 Thread scott.marlowe
On Mon, 3 Mar 2003, Tommi Maekitalo wrote:

 On the results page they list kernels like linux-2.4.18-1tier or 
 linux-2.4.19-rc2 or redhat-stock-2.4.7-10cmp. This sounds really like 
 linux-kernel-versions.
 
 Am Montag, 3. März 2003 13:41 schrieb [EMAIL PROTECTED]:
   OSDL has just come out with a set of open-source database benchmarks:
   http://www.osdl.org/projects/performance/
  
   The bad news:
   This tool kit works with SAP DB open source database versions 7.3.0.23
   or 7.3.0.25.
  
   (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.
 
  When they translate things from German, sometimes wordings change :-).
  --
  output = reverse(moc.enworbbc@ enworbbc)
  http://www.ntlug.org/~cbbrowne/linuxxian.html
  Rules  of the  Evil Overlord  #41. Once  my power  is secure,  I will
  destroy all those pesky time-travel devices.
  http://www.eviloverlord.com/

I think they are testing how tuning the linux kernel impacts the database 
running on top, at least that's the feeling I got from the site.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] Yet another open-source benchmark

2003-03-03 Thread Neil Conway
On Mon, 2003-03-03 at 07:41, [EMAIL PROTECTED] 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 [EMAIL PROTECTED] || PGP Key ID: DB3C29FC




---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


Re: [HACKERS] Yet another open-source benchmark

2003-03-03 Thread Mark Wong
On Mon, 2003-03-03 at 12:29, Neil Conway wrote:
 On Mon, 2003-03-03 at 07:41, [EMAIL PROTECTED] 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 [EMAIL PROTECTED] || 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 - - [EMAIL PROTECTED]
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/


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


[HACKERS] Yet another open-source benchmark

2003-03-02 Thread Tom Lane
OSDL has just come out with a set of open-source database benchmarks:
http://www.osdl.org/projects/performance/

The bad news:
This tool kit works with SAP DB open source database versions 7.3.0.23
or 7.3.0.25.

(In fact, they seem to think they are testing kernel performance, not
database performance, which strikes me as rather bizarre.  But anyway.)

The good news:
We are planning to port this test kit to other databases.

Perhaps someone around here should help out...

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [HACKERS] Yet another open-source benchmark

2003-03-02 Thread Justin Clift
Tom Lane wrote:
OSDL has just come out with a set of open-source database benchmarks:
http://www.osdl.org/projects/performance/
The bad news:
This tool kit works with SAP DB open source database versions 7.3.0.23
or 7.3.0.25.
(In fact, they seem to think they are testing kernel performance, not
database performance, which strikes me as rather bizarre.  But anyway.)
The good news:
We are planning to port this test kit to other databases.
Perhaps someone around here should help out...
Yep, this is the group that have hit a performance limit with SAPDB and 
are 100% definitely looking to move it to PostgreSQL, *if* they can get 
people to assist them.

:-)

Regards and best wishes,

Justin Clift

			regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there.
- Indira Gandhi
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send unregister YourEmailAddressHere to [EMAIL PROTECTED])