Page 1 of 1

ETA on a rebuilding DB

PostPosted: Thu Jan 01, 2009 6:49 am
by myth123
Importing ~26000 files with over 1 million hands to rebuild DB... it's been running since 12/27 about 5pm eastern, just how much longer should I expect this to take?

Re: ETA on a rebuilding DB

PostPosted: Thu Jan 01, 2009 10:32 am
by ptrack pat
PT2 should be able to import 30,000 hands/hour into a PostgreSQL database. You didn't have the auto-rate on import option selected did you? Because that would make it take a lot longer. It also might have been better to do it in batches of files and do a full vacuum/analyze after each import to keep it running faster.