Issue

[MrChairman]

I am , as of yesterday, having similar issue. Only importing one "Active" table when I have four currently open. Hands importing for that one table, the others nothing. And the one that is importing there is no hud. When I try to "stop" table import of hands, the whole program freezes. I have reinstalled, vacuumed the database, restarted, etc. Any suggestions?

[Flag_Hippo]

Try 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

After the housekeeping is complete make sure you then also rebuild the database cache via 'Rebuild Cache -> Full Cache Rebuild'.

If that doesn't resolve the problem please turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce this issue by playing a few hands with 'Play Poker -> Get Hands While Playing' active and then create a support bundle via the 'File -> Create Support Bundle' menu option in PokerTracker 4 before you stop getting hands. When that file has been saved attach your support bundle to a Support Ticket where a technician can review your logs. If you stop getting hands and PokerTracker 4 freezes you will need to grab your log file manually from here before restarting PokerTracker 4:

C:\Users\{Windows Login}\AppData\Local\PokerTracker 4\Logs\PokerTracker4.log

Tutorial: Reporting A Problem

[MrChairman]

Hi. I do not see a Tune PostSQL option under the database>Housekeeping tab. Can you please advise where to find this?

[Flag_Hippo]

If you are on macOS 13+ you may not have that option so you can start from step #2 instead.

[MrChairman]

Hi. Followed suggest steps, but no change. Iis is just locked up in how slow it is running. I will send a log and ticket to support. Thank you.