Page 1 of 2
PT3 100% cpu usage

Posted:
Mon Jan 28, 2008 1:00 pm
by 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.
Re: PT3 100% cpu usage

Posted:
Mon Jan 28, 2008 3:55 pm
by Josh
Are the hands still being imported? Try waiting for the import to complete, then view the data and see how CPU usage is.
Re: PT3 100% cpu usage

Posted:
Mon Jan 28, 2008 4:48 pm
by 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?
Re: PT3 100% cpu usage

Posted:
Mon Jan 28, 2008 5:41 pm
by Josh
You should only have to cluster every 50k-100k hands. Did you cluster after the initial import?
Re: PT3 100% cpu usage

Posted:
Tue Jan 29, 2008 5:50 am
by EB1983
Yes I did. When the manual import was finished it automatically clustered the database.
Re: PT3 100% cpu usage

Posted:
Tue Jan 29, 2008 8:46 am
by Josh
That's strange. Let me know if it continues to do that.
Re: PT3 100% cpu usage

Posted:
Tue Jan 29, 2008 12:25 pm
by 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.
Re: PT3 100% cpu usage

Posted:
Tue Jan 29, 2008 12:26 pm
by Josh
Instead of clustering again, try restarting PT3 and see if the same thing happens.
Re: PT3 100% cpu usage

Posted:
Tue Jan 29, 2008 12:30 pm
by EB1983
I tried that, didn't solve the problem. After clustering the database worked fine again.
Re: PT3 100% cpu usage

Posted:
Tue Jan 29, 2008 12:34 pm
by Josh
Next time it happens, please attach the PokerTracker.log file to a support ticket.