DBT-2 running against PostgreSQL and LVM2

Started by Mark Wongover 22 years ago2 messageshackers
Jump to latest
#1Mark Wong
markw@osdl.org

I just wanted to share that we're on the brink of having an automated
test on our Scalable Test Platform (http://www.osdl.org/stp/) that
features our DBT-2 workload, a fair use implementation of the TPC-C,
that uses PostgreSQL 7.4 and LVM2 on Linux on our 8-processor systems.

Currently the test only works with a scale factor of 1 warehouse, which
amounts to about a 500MB of raw data. You can request tests at this
scale factor at the above link and typing "-w 1" in the "Optional Script
Parameters" field.

We're working through some Linux kernel related issues so we can run
more interesting workloads against larger databases. I'm planning to
allow an option for either a 100 and 200 warehouse database to be built.

I wanted to let people know early for feedback on the kind of data that
is reported from the test. You can see a sample of a test report here:
http://khack.osdl.org/stp/284353/

Thanks!
--
Mark Wong - - markw@osdl.org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 626-2455 x 32 (office)
(503) 626-2436 (fax)
http://developer.osdl.org/markw/

#2Timothy D. Witham
wookie@osdl.org
In reply to: Mark Wong (#1)
Re: [Stp-devel] DBT-2 running against PostgreSQL and LVM2

Thanks for getting this out.
Tim

On Tue, 2003-12-09 at 16:27, markw@osdl.org wrote:

I just wanted to share that we're on the brink of having an automated
test on our Scalable Test Platform (http://www.osdl.org/stp/) that
features our DBT-2 workload, a fair use implementation of the TPC-C,
that uses PostgreSQL 7.4 and LVM2 on Linux on our 8-processor systems.

Currently the test only works with a scale factor of 1 warehouse, which
amounts to about a 500MB of raw data. You can request tests at this
scale factor at the above link and typing "-w 1" in the "Optional Script
Parameters" field.

We're working through some Linux kernel related issues so we can run
more interesting workloads against larger databases. I'm planning to
allow an option for either a 100 and 200 warehouse database to be built.

I wanted to let people know early for feedback on the kind of data that
is reported from the test. You can see a sample of a test report here:
http://khack.osdl.org/stp/284353/

Thanks!

--
Timothy D. Witham - Lab Director - wookie@osdl.org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton OR, 97005
(503)-626-2455 x11 (office) (503)-702-2871 (cell)
(503)-626-2436 (fax)