pgbench-testing.sh

#just in case
./scripts/pg-stop-prefix 15				# master
./scripts/pg-stop-prefix 15-lock		# with patch

for v in 15 15-lock
do
	echo -e "autovacuum = off\nfsync = off\nfull_page_writes = off\nmax_worker_processes = 99\nmax_parallel_workers = 99\n" > ./pgdata$v/postgresql.auto.conf
	./scripts/pg-start-prefix $v
	./pgbin15/bin/pgbench -d postgres -i -I dtgv -s 10 --unlogged-tables
	./scripts/pg-stop-prefix $v
done

for i in {1..3}
do

	for v in 15 15-lock
	do

		./scripts/pg-start-prefix $v
		psql -dpostgres -c "vacuum full pgbench_tellers;"

		echo  "pgbench #$i on $v"
		echo "-----------------------"
		./pgbin$v/bin/pgbench postgres -f ./update-only.sql -s 10 -P10 -M prepared -T 600 -j 5 -c 50
		./scripts/pg-stop-prefix $v
	done
done