From: | Jenny Zhang <jenny(at)osdl(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Cc: | osdldbt-general(at)lists(dot)sourceforge(dot)net |
Subject: | OSDL Database Test Suite 3 is available on PostgreSQL |
Date: | 2003-08-01 18:04:10 |
Message-ID: | 1059761051.1535.396.camel@ibm-a |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Elielson Fontanezi | 2003-08-01 18:06:43 | DROP TRIGGER |
Previous Message | Francisco J Reyes | 2003-08-01 17:26:47 | Domains (Was [PERFORM] Views With Unions) |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-08-01 18:57:44 | Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL |
Previous Message | Josh Berkus | 2003-08-01 17:44:03 | Re: How number of columns affects performance |