Slow performance

[CherryWaves]

Hi, if I am experiencing slow performance, does creating a brand new database solve most of these issues?

[Flag_Hippo]

If the issue you have is database specific then a new database can be a solution but there may be a root cause which might appear after time again on a new database if it is not addressed. Poor performance can also be caused by configuration issues which wouldn't necessarily be resolved by creating a new database. If you don't have a large database you can run maintenance by going to 'Database -> Database Management', choosing 'Housekeeping' button and running 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 rebuild the database cache via 'Rebuild Cache -> Full Cache Rebuild' and see if that performs better.

If you are running an older version of PostgreSQL (v9 or v10 then you should consider upgrading to v16):

Guide: Installing PostgreSQL

If you want us to take a look at this in some more detail turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce this issue you've described with performance whatever that is (for example HUD not updating or slow report loading) and then create a support bundle via the 'File -> Create Support Bundle' menu option in PokerTracker 4. When that file has been saved attach your support bundle to a Support Ticket where a technician can review your logs and advise you accordingly.