pgbench -i -s 1 test > /dev/null 2>&1
psql test -c 'vacuum analyze' > /dev/null 2>&1
psql test -c 'checkpoint' > /dev/null 2>&1

echo '\set aid random(1, 100000 * :scale)' > select.sql
echo 'SELECT abalance FROM pgbench_accounts WHERE aid = :aid ORDER BY aid, bid;' >> select.sql


for r in `seq 1 10`; do

        tps=`pgbench -n -S -M simple -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "simple built-in $r $tps"

done

for r in `seq 1 10`; do

        tps=`pgbench -n -S -M prepared -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "prepared built-in $r $tps"

done

for r in `seq 1 10`; do

        tps=`pgbench -n -f select.sql -M simple -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "simple custom $r $tps"

done

for r in `seq 1 10`; do

        tps=`pgbench -n -f select.sql -M prepared -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "prepared custom $r $tps"

done


psql test > /dev/null 2>&1 <<EOF
create index on pgbench_accounts (aid,bid);
create index on pgbench_accounts (bid,aid);
create index on pgbench_accounts (bid,aid,abalance);
create index on pgbench_accounts (aid,bid,abalance);
create index on pgbench_accounts (abalance,aid,bid);
create index on pgbench_accounts (abalance,bid,aid);
create index on pgbench_accounts (bid,abalance,aid);
create index on pgbench_accounts (bid,abalance,aid);
vacuum analyze;
checkpoint;
EOF


for r in `seq 1 10`; do

        tps=`pgbench -n -S -M simple -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "simple-2 built-in $r $tps"

done

for r in `seq 1 10`; do

        tps=`pgbench -n -S -M prepared -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "prepared-2 built-in $r $tps"

done

for r in `seq 1 10`; do

        tps=`pgbench -n -f select.sql -M simple -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "simple-2 custom $r $tps"

done

for r in `seq 1 10`; do

        tps=`pgbench -n -f select.sql -M prepared -T 30 test 2>&1 | grep excluding | awk '{print $3}'`

        echo "prepared-2 custom $r $tps"

done