PlanetScale for Postgres is here. Request early access
Navigation

Prerequisites

These commands assume you have sysbench v1.0.2 or greater installed as well as the Percona TPCC scripts.

Prepare the database

./tpcc.lua \
  --pgsql-host=${DB_HOST} \
  --pgsql-port=${DB_PORT} \
  --pgsql-password=${DB_PASSWORD} \
  --pgsql-user=${DB_USER} \
  --pgsql-db=${DB_NAME} \
  --tables=20 \
  --scale=250 \
  --use_fk=0 \
  --threads=20 \
  --report-interval=1 \
  --db-driver=pgsql \
  prepare 

Run the benchmark

./tpcc.lua \
  --pgsql-host=${DB_HOST} \
  --pgsql-port=${DB_PORT} \
  --pgsql-password=${DB_PASSWORD} \
  --pgsql-user=${DB_USER} \
  --pgsql-db=${DB_NAME} \
  --tables=20 \
  --scale=250 \
  --use_fk=0 \
  --time=300 \
  --threads=${THREAD_COUNT} \
  --report-interval=1 \
  --histogram=off \
  --percentile=99 \
  --db-driver=pgsql \
  run