Stats Benchmark

General

This is a re-distribution of the Stats dataset and workload, adapted for different database systems.

The original dataset was uploaded by Stack Exchange, Inc. to archive.org and licensed under CC-BY-SA 4.0 terms. Our dump is based on the distribution from the CTU Relational Dataset Repository, but re-packaged for PostgreSQL and DuckDB.

The benchmark queries were first presented by Han et al. in their paper "Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation" (Proc. VLDB, Vol. 15, Issue 4) (DOI 10.14778/3503585.3503586). We extracted the queries from the official Github Repo of the publication and provide the as individual SQL files.

Import for PostgreSQL

The PostgreSQL dump was created using PostgreSQL 16, so it should work on all Postgres version starting from PG 16.

To load the dump, first create a new Postgres database. Afterwards, run pg_restore on the dump:

$ createdb stats

$ pg_restore -n public -O -d stats stats_dump.pg

If you do not have the pg_hint_plan extension available on your server, you might see a couple of warnings during the import. These are safe to ignore. For reference, we also provide the raw schema for Postgres. Similarly, a mismatch of the user name may also produce some error messages. You can ignore those to, Postgres proceeds with the restore anyway.

Import for DuckDB

Simply run DuckDB on the dump, no further steps required.

$ duckdb stats.duckdb

For reference, we also provide the raw schema for DuckDB.