Skip to content
/ pg-tpch Public
forked from sshtmc/pg-tpch

PostgreSQL-compatible benchmark TPC-H, with some wrapper scripts

Notifications You must be signed in to change notification settings

nehirs/pg-tpch

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Instructions:

To make this profiler work, you should compile PostgreSQL from source. I will give you the instructions to do this for the version 9.2 of PostgreSQL, on Ubuntu 12.04. You might have to change some steps for other versions of Linux, or for other versions of PostgreSQL.

Install all dependencies of Postgres

sudo apt-get build-dep postgresql

Install the dependencies of the scripts

sudo apt-get install graphviz libreadline5-dev zlib1g-dev pgtune

Download, build, and install a custom version of Postgres

wget http://ftp.postgresql.org/pub/source/v9.2.1/postgresql-9.2.1.tar.bz2
tar xf postgresql-9.2.1.tar.bz2
cd postgresql-9.2.1/
CFLAGS="-fno-omit-frame-pointer -rdynamic" ./configure --prefix=$HOME/pg92 --enable-debug
make -j$(grep -c ^processor /proc/cpuinfo)
make install

Add Postgres to the path. I assume you are using bash (the default)

echo -e "\nexport PATH=\$HOME/pg92/bin:\$PATH" >>~/.bashrc

Now logout and login. If you don't want to logout at this time, you should run run the following command in all new terminals, until you do logout and login again

export PATH=$HOME/pg92/bin:$PATH

To install the 'perf' profiler and the dependencies

full_version=$(uname -r)
flavour_abi=${full_version#*-}
flavour=${flavour_abi#*-}
version=${full_version%-$flavour}
sudo apt-get install linux-tools-common linux-tools-${version}

You are now ready to create and populate the TPC-H database and the tables:

./tpch_prepare

And after it finishes, run the queries and generate the call graphs:

./tpch_runall_seq

This will create a directory perfdata, and put all the evaluation results in there.

You may also use a custom directory for the performance results, by giving an argument to the tpch_runall_seq:

./tpch_runall_seq my-config

This will create a directory perfdata-my-config and put the results in it.

About

PostgreSQL-compatible benchmark TPC-H, with some wrapper scripts

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C 44.9%
  • Python 27.2%
  • Perl 21.0%
  • Shell 4.9%
  • Objective-C 2.0%