ETA on a rebuilding DB

Hold'em or Poker Tracker Hold'em related posts go here

ETA on a rebuilding DB

Postby myth123 » Thu Jan 01, 2009 6:49 am

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?
myth123
 
Posts: 13
Joined: Tue Apr 01, 2008 12:51 pm

Re: ETA on a rebuilding DB

Postby ptrack pat » Thu Jan 01, 2009 10:32 am

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.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PokerTracker Holdem

Who is online

Users browsing this forum: No registered users and 2 guests