Table of Contents

OSDL DBT-1 home page

OSDL-DBT-1 home page.

OSDL-DBT-1 simulates a web server to give results similar to the proprietary TPC-W benchmark.





Required packages

Compiling you own Postgrsql

Setting Up the Database

Environment Variables

Getting the source


Setup the benchmark database

  1. cd into the datagen directory and run datagen

    ./datagen  -d PGSQL -i 10000 -u 10 -p $DBPATH
    This will produce a small sample. You may want to increase the number of items and users in the system.
    • -i, has to be 1000, 10000 or 100000.

    • -u, can be any positive integer.

    • NOTE with values of -i 100000 and -u 10000, data generation will take considerable time and consume a lot of disk space, for example the following was produced on an 2 * i2 1500 MHz rx2600.

      pgsql@vanilla:~/dbt1-BK/scripts/pgsql$ ls -lh /tmp/DBT1-files/
      total 31G
      -rw-r--r--    1 pgsql    root         5.8G Aug 26 15:12
      -rw-r--r--    1 pgsql    root         8.9M Aug 26 14:59
      -rw-r--r--    1 pgsql    root         2.8G Aug 26 15:43
      -rw-r--r--    1 pgsql    root          14G Aug 26 14:59
      -rw-r--r--    1 pgsql    root          51M Aug 26 14:27
      -rw-r--r--    1 pgsql    root         6.3G Aug 26 15:43
      -rw-r--r--    1 pgsql    root         2.7G Aug 26 15:43
        real    75m34.662s
        user    72m56.411s
        sys     2m29.652s
  2. cd into the scripts/pgsql and run the

    ./ "-c tcpip_socket=[on|off]" 0 0
  3. The -c flag above will depend on how the postmater server is started, see /var/log/pgsql/postgresql.conf for more details.

    The first argument is rather pointless unless you would like to pass options to the postmaster server --- see man postmaster.

    • pgsql@vanilla:~/dbt1-BK/scripts/pgsql$ ls -lh ../../../postgresDB/
      total 36M
      -rw-r--r--    1 pgsql    root         5.8M Aug 24 12:26
      -rw-r--r--    1 pgsql    root         894K Aug 24 12:26
      -rw-r--r--    1 pgsql    root         2.7M Aug 24 12:26
      -rw-r--r--    1 pgsql    root          13M Aug 24 12:26
      -rw-r--r--    1 pgsql    root         5.0M Aug 24 12:26
      -rw-r--r--    1 pgsql    root         6.1M Aug 24 12:26
      -rw-r--r--    1 pgsql    root         2.5M Aug 24 12:26
        real    1m39.830s
        user    0m0.236s
        sys     0m0.229s

Running the benchmark

Run Times

Getting Results




IA64wiki: OSDL-DBT-1 (last edited 2012-02-15 02:18:51 by PeterChubb)

Gelato@UNSW is sponsored by
the University of New South Wales National ICT Australia The Gelato Federation Hewlett-Packard Company Australian Research Council
Please contact us with any questions or comments.