jaopaulolc/pg-benchmark

Scripts and Workloads to benchmark PostgreSQL

PostgreSQL Benchmark Setup

This repository contains the source code and scripts to build & run benchmarks with PostgreSQL.

Building & Setting up PostgreSQL

Cloning the repo

After cloning the repo, you must get the submodules.

git submodule update --init --recursive

Checkout files in LFS

git lfs fetch && git lfs checkout

Extract benchmark source code

./scripts/extract-files.sh

Edit variable in scripts/setenv.sh

Ajust variables to point to LLVM installation, readline library, and other required files.

Source scripts/setenv.sh

source scripts/setenv.sh

Build & Install PostgreSQL

./scripts/build-and-install-postgresql.sh [ijit or ""] [-mcpu option]

Add PostgreSQL tools to path

source ./scripts/pg-setenv.sh [-mcpu option]

Start DB server

./scripts/start-db-server.sh <db base dir name (e.g. tpch)>

Running TPC-H queries

Now that the PostgreSQL server is running, the database can be initialized with according to the TPC standard.

Build dbgen & qgen and create & populate testing database

This step will build the tools from TPC-H to generate the data for populate the database (dbgen). It will also build the tool to generate the queries (qgen). After this step the database is ready for performance measurements.

./scripts/build-and-setup-tpch.sh

Running queries

TODO: check answers

./scripts/run-tpch.sh

Running TPC-C

With PostgreSQL up and runnnig, the benchmark can be executed. Unfortunatelly, it is an interactive program and provides little room for scripting. Please use the builtin menu after running the following command.

./scripts/run-tpcc.sh