pg-benchmark.sh

#!/bin/bash

PGPASSWORD="benchmarking" pgbench \
  --initialize \
  --init-steps=dtgpf \
  --scale=2000 \
  --host=$IPADDRESS \
  --username=benchmarking

for script in tpcb-like; do
  for client in 1 4 8 12 ; do
    for i in 1 2 3; do
      echo "====================================" >> output-$script-$client.txt
      echo "run=$i | script=$script | client=$client" >> output-$script-$client.txt
      PGPASSWORD="benchmarking" pgbench \
        --builtin=$script \
        --client=$client \
        --jobs=6 \
        --time=600 \
        --host=$IPADDRESS \
        --username=benchmarking >> output-$script-$client.txt
    done
  done
done