#!/bin/bash # This should improve echo "select two from tenk1 order by two offset 1000000" > bench.sql echo Test1 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps # This should stay the same echo "select * from tenk1 order by two offset 1000000" > bench.sql echo Test2 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps # This should improve echo "select tenthous from tenk1 order by tenthous offset 1000000" > bench.sql echo Test3 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps # This should stay the same echo "select * from tenk1 order by tenthous offset 1000000" > bench.sql echo Test4 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps # This should improve echo "select stringu1 from tenk1 order by stringu1 offset 1000000" > bench.sql echo Test5 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps # This should improve echo "select stringu2 from tenk1 order by stringu2 offset 1000000" > bench.sql echo Test6 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps # This should stay the same echo "select * from tenk1 order by stringu2 offset 1000000" > bench.sql echo Test7 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps # This should improve echo "select twenty from tenk1 order by twenty offset 1000000" > bench.sql echo Test8 pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps pgbench -n -f bench.sql -T 10 regression | grep tps