purging extremely slow

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

purging extremely slow

Postby pepsin » Tue Nov 20, 2012 5:45 am

Long story short, I had to abandon PT4 and use PT3 to reimport all my hands there, and then purge all my observed hands to make the db smaller (from 9mill to 1mill). This all went fine for a while, but now as there are about 1 mill observed hands left everything is soo slow. Estimated time to purge about 300k observed hands is now around 240 hours, this took 15 mins some days ago. I've run vacuum, analyze and update cache a couple of times with variable success, as this is also extremely slow and PT sometimes lose access to the db while housekeeping. Any advice?

Thanks
pepsin
 
Posts: 207
Joined: Fri Jan 25, 2008 7:01 pm

Re: purging extremely slow

Postby kraada » Tue Nov 20, 2012 9:24 am

What version of PT3 are you using? Have you tried a REINDEX?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests