Thread: DBT-2 running against PostgreSQL and LVM2

DBT-2 running against PostgreSQL and LVM2

From
markw@osdl.org
Date:
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/


Re: [Stp-devel] DBT-2 running against PostgreSQL and LVM2

From
"Timothy D. Witham"
Date:
  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)