TPC-DS 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-DS is a database benchmark. git clone https://github.com/gregrahn/tpcds-kit.git cd tpcds-kit/tools make OS=MACOS Create the database and load the schema createdb tpcds psql tpcds -f tpcds.sql Generate data ./dsdgen -FORCE -VERBOSE Load the data for i in `ls *.dat`; do table=${i/.dat/} echo "Loading $table..." sed 's/|$//' $i > /tmp/$i psql tpcds -q -c "TRUNCATE $table" psql tpcds -c "\\copy…

Read on ankane.org ↗