Loading stats after making alias taks 15min

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Loading stats after making alias taks 15min

Postby LAAKSOLAHTI » Sat Aug 19, 2023 11:20 am

Hi,

After I combined nicknames with aliases, it takes now 15 minutes to load stats. I wonder if I can make it faster in any way? It took only 20sec before alias thing :(

Hmm, it looks like todays stats are almost instant so it's not a huge problem. I wonder if there is any way to "pre download" stats until some day so it would take those stats instant and only stats after that date it would seek from databases? That would be amazing feature.
LAAKSOLAHTI
 
Posts: 5
Joined: Thu May 24, 2018 3:41 am

Re: Loading stats after making alias taks 15min

Postby WhiteRider » Sat Aug 19, 2023 3:52 pm

It should not be necessary after adding an alias, but you may want to try rebuilding your cache and see if that resolves the issue. In PokerTracker go to Database -> Database Management. Click the 'Rebuild Cache' button and select 'Full Cache Rebuild'.

If that does not resolve the issue then perform a full database housekeeping. In PokerTracker go Database -> Database Management. Click the 'Housekeeping' button and run the following in this order:

1. Tune PostgreSQL (this only needs to be completed once ever. If this step fails, you can safely skip to step #2)
2. Reindex
3. Cluster
4. Vacuum/Analyze
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 35 guests