#!/bin/bash

dbname=postgres
secs=10
rows=1000000
extra_cols_start=0
extra_cols_end=40
extra_cols_increment=10
psql -c "alter system set max_parallel_workers_per_gather = 0;" $dbname
psql -c "alter system set jit = 0;" $dbname
psql -c "select pg_reload_conf();" $dbname
psql -c "create extension if not exists pg_prewarm;" $dbname
psql -c "create extension if not exists deform_bench;" $dbname
psql -c "create table if not exists deform_results (machine text not null, cc text not null, branch text not null, test_id int not null, extra_columns int not null, run_id int not null, milliseconds float4 not NULL);" $dbname

test_id=1

for extracol in ", b int not null default 0" ", b int default null"
do
	for firstcol in "c int not null default 0" "c text not null default '0'" "c int null" "c text null"
	do
		for c in $(seq $extra_cols_start $extra_cols_increment $extra_cols_end)
		do
			tablename="t_${test_id}_${c}"
			psql -c "drop table if exists $tablename" $dbname
			sql="create table $tablename ($firstcol"
			for i in $(seq 0 $c)
			do
				sql="$sql,c$i int not null default 0"
			done
			sql="$sql,a int not null$extracol);"
			psql -c "$sql" $dbname

			psql -c "insert into $tablename (a) select a from generate_series(1,$rows) a;" $dbname
			psql -c "vacuum freeze analyze $tablename;" $dbname
		done
		let "test_id=test_id+1"
	done
done

psql -c "checkpoint;" $dbname