bench_128_2dbs.sh

template=/var/tmp/data_jeff_bench_template/
export PGDATA=/mnt/db1/ssd/tables/.t/data_jeff_bench/
port=55432
pgbench_args=(-c128 -j128 -P -T60 -s100 -p ${port})

set -eux

for i in {1..1} ; do
    rsync -av --delete \
	"${template}" \
	"${PGDATA}"
    pwd
    /usr/bin/time ./postgres -D "${PGDATA}" -p ${port} &
    ppid=$!
    pid=$(pgrep -P $ppid )
    sleep 15

    typeset -a benchpids
    for db in bench_scale100_{1..2} ; do
        /usr/pgsql-9.1noslock/bin/pgbench \
	    "${pgbench_args[@]}" "${db}" &
	benchpids[${#benchpids[@]}]=$!
    done
    wait ${benchpids[*]}

    kill $pid
    wait
    while pgrep -f "${port}" ; do
	echo postgresql still running - hm
	sleep 1
    done
done