#!/bin/bash

for q in "select a,sum(b) from ab group by a;" "select a,string_agg(b::text,',') from ab group by a;"
do
	for i in {0..32}
	do
			echo Testing with $i parallel workers: $q
			psql -c "alter table ab set (parallel_workers = $i);" postgres
			echo "select a,sum(b) from ab group by a;" > bench.sql
			pgbench -f bench.sql -n -T 3 postgres | grep latency
	done
done