DBT-2

From PostgreSQL wiki
Jump to navigationJump to search

DBT-2

Current source may be checked out from:

git clone git://osdldbt.git.sourceforge.net/gitroot/osdldbt/dbt2

Note that the current version doesn't `make` correctly if more than one database is installed on your system. Patches welcome. :)

User Guide

Installing PostgreSQL

The OSDL-DBT-2 test kit was originally ported to work with PostgreSQL 7.3. This doc is being updated for the 8.4beta2 version of Pg. Current source code for PostgreSQL can be downloaded from http://www.postgresql.org

Before running the configure script for PostgreSQL, alter src/include/pg_config_manual.h so that INDEX_MAX_KEYS = 64.

For a standard install:

./configure --prefix=<installation dir>
make
make install

Check ./configure --help and the PostgreSQL documentation for other configuration options.

DO NOT run initdb or start the postmaster at this point. Our script will create the database and start the database engine for you.

Installing the DBT-2 Test Kit

The latest stable version of the kit can be found on PostgreSQL's git repo at:

git clone git://osdldbt.git.sourceforge.net/gitroot/osdldbt/dbt2

Follow the instructions in INSTALL. Check the README(s) included with the source for information specific to your environment.

Things to check if you are having problems building:

  • is pg_config in your path? (e.g. /usr/local/pgsql/bin)

Building the Database

Sizing

Creating the Database

Backing Up & Restoring the Database

Running the DBT-2 Test Kit

Finding & Interpreting the Results

Customize Your Tests

Additional resources