Imported 1.5 Million hands.. REALLY slow..

[genemish]

Full ring... So I should expect roughly 15 of these 1gb files? U guys need to implement a progress indicator into the housekeeping process....

[kraada]

Cluster is run entirely by PostgreSQL - it's not a PT3 function. All PT3 does is call CLUSTER on the PT3 database (well, it calls ANALYZE first, but that takes a negligible amount of time comparatively), and PostgreSQL takes care of the rest.

The only housekeeping function that PT3 actually does is the cache update, and if you have logging enabled the pokertracker.log file does have how much is complete in percentages of players, but it doesn't translate directly to time left easily as one player who has a lot more hands will take longer (obviously) than one player who has just two hands.

[genemish]

ok, i got it.. here's a snapshot.. i am already at 15.6 GB..

thoughts?

[genemish]

further proof i am not crazy....

[WhiteRider]

I'd suggest that you leave it running as long as there is activity, and just let it finish. Once the DB has been clustered it shouldn't take so long in future.

[genemish]

I'd suggest that you leave it running as long as there is activity, and just let it finish. Once the DB has been clustered it shouldn't take so long in future.

yea, my thoughts exactly..

i was thinking that maybe i shouldve imported say 100k hands at a time, perform housekeeping and then proceed..

[genemish]

just checked... now the folder is down in size to 12.4GB... is this normal during the clustering process?

[genemish]

now 12.6G...

[genemish]

now up to 13.2GB again... starting 20th hour.. LOL... next update in the morning

[genemish]

finished at 5:30am this morning.. final size 12.4GB, total time it took was 27 hours..

will test drive tonight to check performance.