Prerequisites

These commands assume you have sysbench v1.0.2 or greater installed.

Prepare the database

sysbench oltp_read_only
  --pgsql-host=${DB_HOST} \
  --pgsql-port=${DB_PORT} \
  --pgsql-password=${DB_PASSWORD} \
  --pgsql-user=${DB_USER} \
  --pgsql-db=${DB_NAME} \
  --tables=10 \
  --table-size=130000000 \
  --threads=2 \
  --report-interval=1 \
  --db-driver=pgsql \
  prepare

Run the OLTP Read-only benchmark

sysbench oltp_read_only \
  --pgsql-host=${DB_HOST} \
  --pgsql-port=${DB_PORT} \
  --pgsql-password=${DB_PASSWORD} \
  --pgsql-user=${DB_USER} \
  --pgsql-db=${DB_NAME} \
  --tables=10 \
  --table-size=130000000 \
  --time=300 \
  --threads=${THREAD_COUNT} \
  --report-interval=1 \
  --histogram=off \
  --percentile=99 \
  --db-driver=pgsql \
  run