#!/bin/bash

psql -c "select pg_prewarm('t_int'),pg_prewarm('t_text'),pg_prewarm('t_mixed');" postgres

for sql in "select distinct a,b from t_int;" "select distinct a,b from t_text;" "select distinct a,b from t_mixed;" "select distinct a,b from (select sum(a) over (order by a rows 2 preceding) a, b from t_int) q;" "select distinct a,b from (select sum(a) over (order by a rows 2 preceding) a, b from t_int order by a, b) q;" "select distinct a,b from (select string_agg(a, ', ') over (order by a rows 2 preceding) a, b from t_text) q;" "select distinct a,b from (select string_agg(left(a, 100), ', ') over (order by a rows 2 preceding) a, b from t_text) q;"
do
	echo "set enable_hashagg=0;" > bench.sql
	echo "set work_mem = '10GB';" >> bench.sql
	echo "$sql" >> bench.sql
	pgbench -n -f bench.sql -M prepared -T 60 postgres | grep latency
done