for t in 000000010000000000000001 000000010000000000000006 000000010000000000000008 16398 shakespeare.txt mr dickens mozilla nci ooffice osdb reymont samba sao webster x-ray xml; do

	echo "SELECT length(substr(test_data, 0, 100)) FROM test_data WHERE test_name = '$t'" > prefix.sql
	echo "SELECT length(substr(test_data, test_length/2, 100)) FROM test_data WHERE test_name = '$t'" > infix.sql
	echo "SELECT length(substr(test_data, test_length - 100, 100)) FROM test_data WHERE test_name = '$t'" > suffix.sql

	p=`pgbench -n -T 60 -f prefix.sql test | grep excluding | awk '{print $3}'`
	i=`pgbench -n -T 60 -f infix.sql test | grep excluding | awk '{print $3}'`
	s=`pgbench -n -T 60 -f suffix.sql test | grep excluding | awk '{print $3}'`

	echo $t $p $i $s

done