echo "Init the database flag:$1"

./pg_ctl -D ../../data start
sleep 5

if [ "$1" == 1 ]
then
	./pgbench -i -s 75 postgres
	./psql postgres -c "checkpoint"
fi

./psql postgres -c "create extension cache_scan"
./psql postgres -c "CREATE TRIGGER pgbench_accounts_cache_row_sync AFTER INSERT OR UPDATE OR DELETE ON pgbench_accounts FOR ROW EXECUTE PROCEDURE cache_scan_synchronizer();"
./psql postgres -c "CREATE TRIGGER pgbench_accounts_cache_stmt_sync AFTER TRUNCATE ON pgbench_accounts FOR STATEMENT EXECUTE PROCEDURE cache_scan_synchronizer();"
./psql postgres -c "select aid, abalance from pgbench_accounts"

for i in 1 2 4 8 
do
	echo "Test for clients $i and threads $i"
	./psql postgres -c "checkpoint"
	./pgbench -c $i -j $i -N -T 300 postgres
done

./psql postgres -c "checkpoint"
./pg_ctl -D ../../data stop -m i
sleep 5
./pg_ctl -D ../../data stop -m i