BASEPATH=$PATH
bin=~/git-clone-postgresql/postgresql/TMP/postgres/bin
export PATH=$bin:$BASEPATH

psql -d postgres -c "create extension pageinspect"
psql -d postgres -c "\i /home/edb/git-clone-postgresql/postgresql/test_squeeze_hindex.sql"

rm /tmp/file1

for i in `seq 1 274671`; do psql -d postgres -c "\t on" -c "SELECT type FROM hash_page_stats(get_raw_page('con_hash_index', $i));" >> /tmp/file1; done

rm file.txt
echo "=====Number of bucket and overflow pages before delete=====" >> file.txt
sort /tmp/file1 | uniq -c | sort -nr >> file.txt

for i in `seq 100 200`; do psql -d postgres -c "DELETE FROM con_hash_index_table WHERE con_hash_index_table.keycol = $i;"; done
psql -d postgres -c "vacuum"

rm /tmp/file2

for i in `seq 1 274671`; do psql -d postgres -c "\t on" -c "SELECT type FROM hash_page_stats(get_raw_page('con_hash_index', $i));" >> /tmp/file2; done

echo "=====Number of bucket and overflow pages after delete=====" >> file.txt
sort /tmp/file2 | uniq -c | sort -nr >> file.txt

mv file.txt result_squeeze_hindex.txt
