#! /bin/bash

# whether to create table spaces
do_ts=1

# number of tables (and tablespaces)
nts=16

# table scaling around 128 bytes per row, 8 * 1024 ~ 1MB
scale=8

# where to create the database
DIR=$HOME/tmp/pgdb

# note about table size: scale * nts * 1 MB
# scale nts size
#     8  16 128 MB
#    64  16 1.1 GB

function err()
{
  local status=$1
  shift 1
  echo "error $status: $@" >&2
  exit $status
}

test -d $DIR || err 2 "not test directory"
type initdb || err 3 "initdb not found"

DATA=$DIR/data

initdb $DATA

cat >> $DATA/postgresql.conf <<EOF
log_checkpoints = on
log_min_messages = info
# checkpoint_completion_target = 0.8
checkpoint_flush_after = 16
checkpoint_timeout = 300s
shared_buffers = 2GB
EOF

pg_ctl -D $DATA -l $DATA/postgresql.log start
sleep 10

createdb test || err 4 "cannot create test database"

i=$nts
while [ $i -gt 0 ] ; do
  if [ "$do_ts" ] ; then
    mkdir $DIR/data_$i || err 1 "cannot mkdir $DIR/data_$i"
    psql test -c "CREATE TABLESPACE data_$i LOCATION '$DIR/data_$i';"
    ts="TABLESPACE data_$i"
  else
    ts=""
  fi
  psql test -c "CREATE TABLE stuff_$i(id SERIAL PRIMARY KEY, counter INTEGER NOT NULL DEFAULT 0, stuff TEXT NOT NULL DEFAULT CONCAT(RANDOM(), RANDOM(), RANDOM(), RANDOM(), RANDOM())) $ts;"
  psql test -c "INSERT INTO stuff_$i(id) SELECT i FROM generate_series(1, $scale * 8 * 1024) AS i;"
  let i--
done

psql test -c "VACUUM FULL ANALYZE;"

echo "# ready for testing: scale=$scale nts=$nts do_ts=$do_ts"
echo "# pgbench -P 1 -T 1000 -D scale=$scale -D nts=$nts -j 2 -c 4 -f ts_test.sql > pgbench-$scale-$nts-$do_ts.out"
