DBT-3 is a decision support benchmark driver for relational database systems. Data and workload are based on the TPC-H benchmark specification (http://www.tpc.org/tpch/), although the DBT-3 benchmark does not adhere to all TPC-H rules (e.g., creation of additional secondary index structures). This version of the DBT-3 benchmark is based on the original dbt3 repository that was last updated in 2012 (http://sourceforge.net/p/osdldbt/dbt3/ci/master/tree/). Changes were made such that DBT-3 is now able to run on newer versions of Ubuntu (14.04+), with newer versions of PostgreSQL (9.3+).
- Install PostgreSQL (9.3+)
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -sudo apt -y updatesudo apt install postgresql-14- Export postgresql binary path in your PATH (e.g., by adding the following statement to your .bashrc)
export PATH=$PATH:/usr/lib/postgresql/14/binsudo apt install procmail autoconf gnuplotRead the QuickStart file.
If anything goes wrong, the first thing to try is to clear your PGDATA (defined in scripts/pgsql/pgsql_profile) directory.