QPPNet icon indicating copy to clipboard operation
QPPNet copied to clipboard

TPC-H benchmarked with PostgresSQL dataset

Open JianhuiWei7 opened this issue 2 years ago • 3 comments

I also can not wget the dataset can you also send me a copy of the dataset?

JianhuiWei7 avatar Feb 24 '23 10:02 JianhuiWei7

I can reproduce the issue downloadding The following step in the readme seems it is not working

wget http://www.andrew.cmu.edu/user/jiejiao/data/qpp/postgres/tpch/psqltpch0p1g.zip && unzip psqltpch0p1g.zip
wget http://www.andrew.cmu.edu/user/jiejiao/data/qpp/postgres/tpch/psqltpch1g.zip && unzip psqltpch1g.zip
wget http://www.andrew.cmu.edu/user/jiejiao/data/qpp/postgres/tpch/psqltpch10g.zip && unzip psqltpch10g.zip

Could we have an alternative way to download it?

thanks a lot.

davidbp avatar Sep 01 '23 14:09 davidbp

After examining the dataset preparation process, I believe that the missing dataset should consist of the JSON-format plans generated using the following PostgreSQL command: EXPLAIN (FORMAT JSON, ANALYZE) + <QUERY>.

HennyNile avatar Sep 15 '23 08:09 HennyNile

I forked this repo and succeeded in running the QPPNet with my own dataset. It might be helpful to you. QPPNet

HennyNile avatar Sep 19 '23 02:09 HennyNile