gregrahn / join-order-benchmark

Join Order Benchmark (JOB)
293 stars 85 forks source link

Step 4 taking too long #9

Open minhduchoang301 opened 3 years ago

minhduchoang301 commented 3 years ago

My code has been running at step 4: "transform *gz files to relational schema (takes a while)" for 12 consecutive hours. Is this normal and expected? Thank you

sublime99 commented 3 years ago

It took more than two days on an i5 processor but took only 10 hours on an i7(both 8GB RAM).

tigert1998 commented 3 years ago

It takes me 8 days and it has not finished yet. 😡

EDIT: Restore the pg dump in https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/2QYZBT only takes <30min. Please do not use the script in this repo.