PT3 100% cpu usage

[EB1983]

After playing a session of 5k hands I imported those hands into PT3. Now everytime I switch a tab the cpu usage reaches 100% (i have a dual core processor) and it takes a couple of minutes for all the data to show. According to the windows task manager postgres.exe is responsible for this.

[Josh]

Are the hands still being imported? Try waiting for the import to complete, then view the data and see how CPU usage is.

[EB1983]

PT3 already imported all of the hands. Clustering the database solved the problem. My database is about 100k hands big, so I was a bit suprised I had to cluster the database after importing only 5k hands. After how many hands do you normally have to cluster your database?

[Josh]

You should only have to cluster every 50k-100k hands. Did you cluster after the initial import?

[EB1983]

Yes I did. When the manual import was finished it automatically clustered the database.

[Josh]

That's strange. Let me know if it continues to do that.

[EB1983]

same problem occured after importing another 3k hands...
The problem doesn't seem to exist when I have disabled all filters, but only when I'm filtering for the day I played the 3k hands.

[Josh]

Instead of clustering again, try restarting PT3 and see if the same thing happens.

[EB1983]

I tried that, didn't solve the problem. After clustering the database worked fine again.

[Josh]

Next time it happens, please attach the PokerTracker.log file to a support ticket.