#!/bin/bash

#
# Test program
# Filesystem: /
# Directory: /fast_work/pcopy/pgx_loader_performance_suite
#
# Postgres installation
# Filesystem: /
# Directory: /fast_work/pcopy/pg_para
#
# Data file
# Filesystem: /disk2
# Directory: /disk2/fast_work
#
# Database
# Filesystem: /disk3
# Directory: /disk3/fast_work/testdb
#

DATA_FILE=/disk2/fast_work/data.csv
ls -lh $DATA_FILE
echo ""

for i in {0..1}
do
	# Truncate table
	psql -d test -c "truncate xt"

	# Clear cache
	sudo sh -c "sync; echo 1 > /proc/sys/vm/drop_caches"
	sleep 2

	if [ $i -eq 0 ]; then
		# Run normal copy
		echo "Normal copy"
		time psql -d test -c "copy xt from '$DATA_FILE' WITH (format csv)"
	else	
		# Run parallel copy
		echo "Parallel $i"
		time psql -d test -c "copy xt from '$DATA_FILE' WITH (format csv, parallel $i)"
	fi

	echo ""
	sleep 5
done

