#!/bin/bash
LOOPS=5
BINROOT=/home/horiguti/bin
DATADIR=/home/horiguti/data/data_work_o2
PREC="numeric(10,2)"

killall postgres
sleep 3

run() {
	local BINARY=$1
	local PGCTL=$2/bin/pg_ctl

	if [ "$3" != "" ]; then
	  local SETTING1="set catalog_cache_prune_min_age to \"$3\";"
	  local SETTING2="set catalog_cache_prune_min_age to \"$4\";"
	  local SETTING3="set catalog_cache_prune_min_age to \"$5\";"
	fi

	$PGCTL --pgdata=$DATADIR start
	psql postgres -e <<EOF
create extension if not exists catcachebench;
select catcachebench(0);

$SETTING1

select '${BINARY}' as binary, '1_0' as test, count(a), avg(a)::${PREC}, stddev(a)::${PREC} from (select catcachebench(1) from generate_series(1, ${LOOPS})) as a(a)
UNION ALL select '${BINARY}', '2_0' , count(a), avg(a)::${PREC}, stddev(a)::${PREC} from (select catcachebench(2) from generate_series(1, ${LOOPS})) as a(a);

$SETTING2

select '${BINARY}' as binary, '3_0' as test, count(a), avg(a)::${PREC}, stddev(a)::${PREC} from (select catcachebench(3) from generate_series(1, ${LOOPS})) as a(a);

$SETTING3

select '${BINARY}' as binary, '1_1' as test, count(a), avg(a)::${PREC}, stddev(a)::${PREC} from (select catcachebench(1) from generate_series(1, ${LOOPS})) as a(a)
UNION ALL select '${BINARY}', '2_1' , count(a), avg(a)::${PREC}, stddev(a)::${PREC} from (select catcachebench(2) from generate_series(1, ${LOOPS})) as a(a)
UNION ALL select '${BINARY}', '3_1' , count(a), avg(a)::${PREC}, stddev(a)::${PREC} from (select catcachebench(3) from generate_series(1, ${LOOPS})) as a(a);

EOF
	$PGCTL --pgdata=$DATADIR stop
}

run "master" $BINROOT/pgsql_work_o2 "" "" ""
run "master2" $BINROOT/pgsql_mater_o2m "" "" ""
run "LRU" $BINROOT/pgsql_catexp8_1 "300s" "1s" "0"
run "Full" $BINROOT/pgsql_catexp8_2 "300s" "1s" "0"
run "FullMod" $BINROOT/pgsql_catexp8_3 "300s" "1s" "0"