Home Original page

GitHub - ydb-platform/tpcc-postgres-new: Efficient PostgreSQL TPC-C implementation with a real-time TUI

TPC-C Benchmark for PostgreSQL

A C++20 implementation of the TPC-C benchmark for PostgreSQL. Ported from a YDB CLI implementation. Uses folly futures/promises with C++20 coroutines, libpqxx for PostgreSQL access, and an optional ftxui-based terminal UI.

Dependencies

Requires Clang 16+ (tested with Clang 20) and a running PostgreSQL instance.

folly

folly requires a recent liburing (we had to remove system provided and to install the trunk version). If your system version is too old, build from source:

git clone https://github.com/axboe/liburing.git
cd liburing
./configure && make && sudo make install

Build folly (v2026.03.30.00):

git clone https://github.com/facebook/folly.git ~/packages/folly
cd ~/packages/folly
git checkout -b v2026.03.30.00 v2026.03.30.00
sudo ./build/fbcode_builder/getdeps.py install-system-deps --recursive
python3 ./build/fbcode_builder/getdeps.py --allow-system-packages build \
    --num-jobs $(nproc) --build-type Release

spdlog

System spdlog may conflict with folly's bundled fmt. Build spdlog 1.15.3 against folly's fmt:

cd ~/packages
git clone --branch v1.15.3 --depth 1 https://github.com/gabime/spdlog.git
cd spdlog
cmake -B build -DCMAKE_CXX_COMPILER=clang++-20 \
    -DCMAKE_INSTALL_PREFIX=$HOME/packages/spdlog/install \
    -DSPDLOG_FMT_EXTERNAL=ON \
    -DCMAKE_PREFIX_PATH="$(python3 ~/packages/folly/build/fbcode_builder/getdeps.py show-inst-dir --allow-system-packages)" \
    -DCMAKE_BUILD_TYPE=Release
cmake --build build -j$(nproc)
cmake --install build

libpqxx

Build libpqxx 7.x from source (requires libpq-dev):

cd ~/packages
git clone --branch 7.10.0 --depth 1 https://github.com/jtv/libpqxx.git
cd libpqxx
cmake -B build -DCMAKE_CXX_COMPILER=clang++-20 \
    -DCMAKE_INSTALL_PREFIX=$HOME/packages/libpqxx/install \
    -DCMAKE_BUILD_TYPE=Release \
    -DBUILD_TEST=OFF -DBUILD_DOC=OFF
cmake --build build -j$(nproc)
cmake --install build

ftxui (optional)

Provides a live terminal UI during benchmark runs. Without it, stats are printed to the console.

cd ~/packages
git clone --branch v6.1.9 --depth 1 https://github.com/ArthurSonzogni/FTXUI.git ftxui
cd ftxui
cmake -B build -DCMAKE_CXX_COMPILER=clang++-20 \
    -DCMAKE_INSTALL_PREFIX=$HOME/packages/ftxui/install \
    -DCMAKE_BUILD_TYPE=Release \
    -DFTXUI_BUILD_EXAMPLES=OFF -DFTXUI_BUILD_DOCS=OFF -DFTXUI_BUILD_TESTS=OFF
cmake --build build -j$(nproc)
cmake --install build

Building

FOLLY_INST=$(python3 ~/packages/folly/build/fbcode_builder/getdeps.py show-inst-dir --allow-system-packages)

cmake -B build -DCMAKE_CXX_COMPILER=clang++-20 \
    -DDEPS_PREFIX="$FOLLY_INST" \
    -DCMAKE_PREFIX_PATH="$HOME/packages/spdlog/install;$HOME/packages/libpqxx/install;$HOME/packages/ftxui/install" \
    -DCMAKE_BUILD_TYPE=Release

cmake --build build -j$(nproc)

Running

Quick start

# Create a database
createdb tpcc

# Create schema and indexes
./build/tpcc --command=init

# Load data (10 warehouses, parallel import)
./build/tpcc --command=import --warehouses=10 --load-threads=8

# Verify loaded data
./build/tpcc --command=check --warehouses=10 --after-import

# Run the benchmark (5 minutes)
./build/tpcc --command=run --warehouses=10 --duration=300

# Run consistency checks after benchmark
./build/tpcc --command=check --warehouses=10

# Clean up
./build/tpcc --command=clean

Connection

By default connects to host=localhost dbname=tpcc user=postgres. Override with --connection:

./build/tpcc --command=run --connection="host=myhost dbname=tpcc user=bench password=secret"

Options

Run ./build/tpcc --help for the full list. Key options:

Flag Default Description
--warehouses 1 Number of warehouses (scales data and terminals)
--duration 600 Benchmark duration in seconds
--warmup 0 Warmup period before measurement starts
--threads auto Coroutine threads
--max-inflight auto Max concurrent transactions
--io-threads 4 I/O threads for libpqxx
--no-delays false Disable TPC-C keying/think time delays
--no-tui false Disable terminal UI (console output instead)
--after-import false Check: verify freshly loaded data (stricter invariants)

Testing

Unit tests

Built automatically when Google Test is found (bundled with folly's deps):

cmake --build build --target tpcc_tests -j$(nproc)
./build/tpcc_tests

Simulation mode

Test the coroutine/IO infrastructure without a real database:

# Pure sleep simulation (no DB connection needed)
./build/tpcc --command=run --simulate-ms=50 --duration=10 --no-tui

# SELECT 1 simulation (needs a running PostgreSQL)
./build/tpcc --command=run --simulate-select1=5 --duration=10