search

rabbit721 / QPPNet

36 stars 18 forks source link

TPC-H benchmarked with PostgresSQL dataset #4

Open JianhuiWei7 opened 1 year ago

JianhuiWei7 commented 1 year ago

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

davidbp commented 1 year ago

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.

HennyNile commented 1 year ago

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 commented 1 year ago

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