Re: [osdldbt-general] increasing CPU usage running dbt2 w/pgsql

[Min Xu (Hsu) <xu...@cs...>]

Najarian,,

On Mon, 29 Mar 2004 Najarian, Anoush wrote :
> I see the think time/keying parameters to the run_workload script -- not
> sure what to set them to, though -- I'll try setting them think time to 1/2
> of the default, I suppose.

This is my command line of driver:

../../src/driver -d localhost -tpw 50 -l 100 -wmin 1 -wmax 20 -w 20 -sleep 1
-ktd 0 -ktn 0 -kto 0 -ktp 0 -kts 0 -ttd 100 -ttn 100 -tto 100 -ttp 100 -tts 100
-outdir ../output/0

> I don't know how to do that -- could you help?

Usage: ./src/datagen -w # [-c #] [-i #] [-o #] [-s #] [-n #] [-d <str>]

-w #
        warehouse cardinality
-c #
        customer cardinality, default 3000
-i #
        item cardinality, default 100000
-o #
        order cardinality, default 3000
-n #
        new-order cardinality, default 900
-d <path>
        output path of data files
--sapdb
        format data for SAP DB
--pgsql
        format data for PostgreSQL