pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jenny Zhang <jenny@osdl.org>
To: pgsql-performance@postgresql.org
To: pgsql-general@postgresql.org
Cc: osdldbt-general@lists.sourceforge.net
Subject: OSDL Database Test Suite 3 is available on PostgreSQL
Date: 01 Aug 2003 11:04:10 -0700
Message-ID: <1059761051.1535.396.camel@ibm-a> (raw)

OSDL has ported OSDL Database Test Suite 3(OSDL-DBT3) to PostgreSQL.  
It drives the database with an ad-hoc decision support workload.  It
helps database developers and users to identify database performance
issues.

OSDL-DBT3 is derived from TPC-H benchmark.  TPC-H is an ad-hoc decision
support benchmark.  It has 22 complicated queries doing a lot of
table/index scanning, sorting and grouping by.  Details about TPC-H can
be found at: http://www.tpc.org/tpch/

Though OSDL-DBT3 is based on TPC-H, it deviates from TPC-H
significantly.  It skipped many of the requirements for audit purpose,
as well as added flexibility.  OSDL-DBT3 performance test results are
not comparable to TPC-H results.

OSDL-DBT3 tarball can be downloaded from:
http://sourceforge.net/projects/osdldbt/
The source can be downloaded from source forge cvs tree and osdl bk tree
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/osdldbt/dbt3/
bk://developer.osdl.org/dbt3

OSDL-DBT3 is also implemented on OSDL Scalable Test Platform(STP).  The
platform provides a framework where users run a set of performance and
scalability tests on various hardware platforms.  Currently, OSDL-DBT3
is running against PostgreSQL 7.3.3 only.  We plan to improve it so that
it can run against PostgreSQL patches.  To find more information about
STP, visit: http://www.osdl.org/stp/.  

A sample OSDL-DBT3 test result report can be found at:
http://khack.osdl.org/stp/276912/

Your comments are welcome,
Regards,
Jenny
-- 
Jenny Zhang
Open Source Development Lab Inc 
12725 SW Millikan Way
Suite 400
Beaverton, OR 97005
(503)626-2455 ext 31




view thread (6+ messages)  latest in thread

Message-ID: <1059761051.1535.396.camel@ibm-a>
Permalink:  ../1059761051.1535.396.camel@ibm-a/
Also on:    postgresql.org/message-id/1059761051.1535.396.camel@ibm-a

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: jenny@osdl.org, pgsql-general@postgresql.org, osdldbt-general@lists.sourceforge.net
  Subject: Re: OSDL Database Test Suite 3 is available on PostgreSQL
  In-Reply-To: <1059761051.1535.396.camel@ibm-a>
  References: <1059761051.1535.396.camel@ibm-a>

* 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