TPC-DS in containerized Postgres

Postgres container initialized with TPC-DS data at a specified scale factor.

Building the image

docker build -t postgres-tpcds .

The TPC-DS data are generated during the build process using zabetak/tpcds-tools image. Depending on the scale factor, this process may take a while and require significant disk space.

Usage

The TPC-DS data are loaded into a database named tpcds in the Postgres container. You can run the container with:

docker run --rm --name tpcds_db postgres-tpcds

You can connect to the tpcds database and run any queries using psql:

docker exec -it tpcds_db psql -d tpcds -U postgres