bench_n.sh

application/x-shellscript

Download

if [[ -z "$1" ]] || ! [[ $1 -gt 0 ]] ; then
    echo need concurrency as the single parameter
    exit 1
fi

template=/var/tmp/data_jeff_bench_template/
export PGDATA=/mnt/db1/ssd/tables/.t/data_jeff_bench/
port=55432
db=bench_scale100_1
pgbench_args=(-c$1 -j$1 -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
    
    /usr/pgsql-9.1noslock/bin/pgbench \
	"${pgbench_args[@]}" "${db}"

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