#!/bin/bash

psql -c "select pg_prewarm('t2');" postgres

for i in a a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 a14 a15 a16;
do
		echo Testing $i
		echo "select * from t2 where $i = 0;" > bench.sql
		pgbench -f bench.sql -M prepared -n -T 10 postgres | grep latency
done