TPC-H with Postgres

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

TPC-H is a database benchmark. git clone https://github.com/gregrahn/tpch-kit.git cd tpch-kit/dbgen make -f Makefile.osx Create the database and load the schema createdb tpch psql tpch -f dss.ddl Generate data ./dbgen -vf -s 1 Load the data for i in `ls *.tbl`; do table=${i/.tbl/} echo "Loading $table..." sed 's/|$//' $i > /tmp/$i psql tpch -q -c "TRUNCATE $table" psql tpch -c "\\copy $table FROM…

Read on ankane.org ↗