Exceptionally Long Clustering - PokerTracker

Two Plus Two Forums Archived Forums Sponsored Support Forums PokerTracker

Exceptionally Long Clustering

...

09-03-2009 , 08:17 PM

1p0kerboy

Carpal \'Tunnel

Join Date: Nov 2003 Posts: 11,797

Is this normal?
5 million hands

09-04-2009 , 06:31 AM

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

It's certainly possible - clustering is quite a long process but depends a lot on your computer's resources.
If you do not have enough free space on your hard disk for postgres to make a full copy of your database then it will take significantly longer.
Defragmenting your drive regularly will help performance too.

I guess it will have finished by now, but if not..
Are any of the postgres processes in Task Manager > Processes using CPU?

09-04-2009 , 07:07 AM

1p0kerboy

Carpal \'Tunnel

Join Date: Nov 2003 Posts: 11,797

Still going after 24 hours so I closed PokerTracker.

If you do not have enough free space on your hard disk for postgres to make a full copy of your database then it will take significantly longer.

I have lots of free space.

Defragmenting your drive regularly will help performance too.

I do this regularly.

Are any of the postgres processes in Task Manager > Processes using CPU?

Correction: yes.

09-04-2009 , 10:42 AM

Kraada

See our Commercial Software thread

Join Date: May 2005 Posts: 6,489

If Postgres.exe is still using cpu to any nontrivial degree, clustering is still going. You can also check to see if files in the C:\Program Files\PostgreSQL\8.3\data\base directory are being created or edited. (Note: DO NOT delete these, they are your database.) If no file in that directory has been touched in a while, though, the clustering has hung and you should end the PokerTracker.exe process from the task manager. Ending clustering in that fashion shouldn't cause any lasting problems, though obviously the database will not have finished the cluster.

09-05-2009 , 01:14 PM

1p0kerboy

Carpal \'Tunnel

Join Date: Nov 2003 Posts: 11,797

Hmmm.

I clustered again and this time it was canceled at the 12 hour mark. What could cause it to cancel?

Also, if I cluster again tonight, will the progress that was made over the 12 hour cluster above still be intact, or will it have to start all over?

(I think postgres might not have been working correctly during the first attempt)

Last edited by 1p0kerboy; 09-05-2009 at 01:32 PM.

09-05-2009 , 03:28 PM

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

Clustering is a postgres process which PT3 starts, but it doesn't control.
I don't know why it would be stopped unless something stopped the postgres service.

Have a look at the Event Viewer for anything postgres related (Start > Control Panel > Administrative Tools > Event Viewer) if it happens again, and attach the last few files in the folder: C:\Program Files\PostgreSQL\8.3\data\pg_log to a Support ticket.

...