Skip to content

Fix TPCH benchmark setup #14

Description

@JP-Reddy

The TPCH benchmark setup (scripts/bench_tpch.sh, scripts/setup_tpch_data.sh, bench_suites/tpch_*) is currently broken and needs to run end-to-end. Once running, 1) we want to confirm the extension inserts CREATE_FILTER/USE_FILTER operators on
every query except the cyclic ones, 2) debug the slow queries, and 3) test at larger scale factors.

Tasks:

  • Get the TPCH benchmark setup running end-to-end again (fix setup_tpch_data.sh / bench_tpch.sh).
  • Verify the extension inserts CREATE_FILTER/USE_FILTER operators on all queries except the cyclic ones. Use EXPLAIN checks.
  • Confirm correctness: every query result with the extension should match baseline.
  • Profile and debug the slower queries - identify where the extension hurts or doesn't help.
  • Scale-test at sf=1, sf=30, sf=100, and larger; confirm setup, correctness, and operator insertion hold.
  • Keep the JFP (join filter pushdown) convention: baseline jfp-on, Robust configs jfp-off.
  • Update README.md with the setup + running instructions.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions