Initial database cluster now running for 19 hours

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

Moderator: Moderators

Initial database cluster now running for 19 hours

Postby DrewOnTilt » Sat Oct 11, 2008 1:17 pm

Two days ago I did a re-import on my database of mined hands (actually I created a new DB, converted the old PT2 db, and then imported 300k hands or so from raw HH files). The total number of hands in this DB is just under 4.8 million.

Yesterday the initial database cluster was still running after 14 hours. I stopped it, rebooted my PC, and launched the Housekeeping function again. The initial cluster has been running for 18 hours now. This is not normal - I ran the housekeeping an older version of this database not long ago, and the entire process took only 12 hours. What can I do? Is there any way to tell if the process is still actually running, other than viewing the Task Manager? According to the Task Manager, PT3 and postgresql are actively using the CPU:

[ img ]
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Initial database cluster now running for 19 hours

Postby DrewOnTilt » Sat Oct 11, 2008 1:23 pm

Right after I posted this, the process entered the "Vacuum" phase, so the housekeeping process is not frozen. It is taking a REALLY long time, though. Can somebody put together a few tips on how to speed up housekeeping, and put them in a sticky post?
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Initial database cluster now running for 19 hours

Postby kraada » Sat Oct 11, 2008 5:45 pm

There are two performance tuning FAQs in the FAQ section that may help.

Also, a cluster can take significantly longer if your hard drive is mostly full. The cluster rebuilds the database completely in a fashion which will lead to queries finishing sooner, but since it has to completely rebuild the database unless you have at least as much free space as the size of your database, the cluster process will take markedly longer to complete.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Initial database cluster now running for 19 hours

Postby DrewOnTilt » Sat Oct 11, 2008 7:26 pm

The Size on Disk of my Postgresql/8.2/data file is 28.4 GB
Total Size of Postgresql/8.2/data is 972 GB - not sure what the difference is between "Size" and "Size on disk"
Total HD size is 170GB, of which 62.2 is used

The Housekeeping is still running, now on the Cache update, total run time 25 hours so far.
I'm going to follow the steps recommended here http://www.pokertracker.com/forums/viewtopic.php?f=45&t=10393 once the cache is complete.
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests