benchmark.sh

#!/bin/bash

psql postgres -t -c 'DROP DATABASE test'
psql postgres -t -c 'CREATE DATABASE test'
psql test -t < dbgen/dss.ddl

psql test -t -c '\timing' -c "\\copy customer FROM 'data/customer.tbl' DELIMITER as '|'"
psql test -t -c '\timing' -c "\\copy lineitem FROM 'data/lineitem.tbl' DELIMITER as '|'"
psql test -t -c '\timing' -c "\\copy nation FROM 'data/nation.tbl' DELIMITER as '|'"
psql test -t -c '\timing' -c "\\copy orders FROM 'data/orders.tbl' DELIMITER as '|'"
psql test -t -c '\timing' -c "\\copy partsupp FROM 'data/partsupp.tbl' DELIMITER as '|'"
psql test -t -c '\timing' -c "\\copy part FROM 'data/part.tbl' DELIMITER as '|'"
psql test -t -c '\timing' -c "\\copy region FROM 'data/region.tbl' DELIMITER as '|'"
psql test -t -c '\timing' -c "\\copy supplier FROM 'data/supplier.tbl' DELIMITER as '|'"

psql test -t -c 'VACUUM ANALYZE'

zsh ./run.sh 2>&1 | tee log.txt