Database import slow even after housekeeping

[noahband]

Hi All,

I recently moved my windows DB onto my Macbook Pro, and whenever I launch PT4 I get an error that asks me to perform database housekeeping. Import times are slow while playing and often during a session the HUD will stop updating on one or more tables. I've performed all the steps in the database housekeeping guide and done a full cache rebuild. Is this a common issue? How should I proceed? The software is close to unusable.

Thanks

[Flag_Hippo]

So we can investigate that and see more about your current setup please turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce the problem with the slow importing and then attach your support bundle to a Support Ticket where a technician can review your logs and advise you accordingly based on the information there. The support bundle is created via the 'File -> Create Support Bundle' menu option in PokerTracker 4. When that's done try creating and using a new database and that may allow you to continue using PokerTracker 4 at the tables in the meantime.

[Glaucou]

So we can investigate that and see more about your current setup please turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce the problem with the slow importing and then attach your support bundle to a Support Ticket where a technician can review your logs and advise you accordingly based on the information there. The support bundle is created via the 'File -> Create Support Bundle' menu option in PokerTracker 4. When that's done try creating and using a new database and that may allow you to continue using PokerTracker 4 at the tables in the meantime.

I have the same problem! :cry:
I already do the Rebuild Cache and all Housekeeping.
I change my Mac recently and I needed to create another Database.

[Flag_Hippo]

If you are using PostgreSQL v12 then please uninstall it, download and install PostgreSQL v16 and then restore your database there - see this guide.

[Glaucou]

If you are using PostgreSQL v12 then please uninstall it, download and install PostgreSQL v16 and then restore your database there - see this guide.

I followed the step-by-step guide you posted here, and now my Poker Tracker is processing hands perfectly and very quickly. 8-)

[Flag_Hippo]

I'm pleased to hear it and thanks for confirming this helped.

[MrChairman]

Hi. I have slow database issues as well on my Mac. Read this and wanted to upgrade my postgreSQL 12 to 16 as advised. My uninstall-postrgeSQL app does not open though and I cannot get it to run (double click, open from finder, etc.). Any thoughts on how to get it to work so I can properly remove v12 and install v16?

[Flag_Hippo]

Hi. I have slow database issues as well on my Mac. Read this and wanted to upgrade my postgreSQL 12 to 16 as advised. My uninstall-postrgeSQL app does not open though and I cannot get it to run (double click, open from finder, etc.). Any thoughts on how to get it to work so I can properly remove v12 and install v16?

You can uninstall PostgreSQL manually following this guide and proceed from step #2 if the uninstaller isn't working for you. You can also install PostgreSQL v16 without first uninstalling PostgreSQL v12 - it should default to port 5433 if PostgreSQL v12 is currently using port 5432.

[ThrustWorld]

Hi,
I am having the same problem, I am using postgreSQL 16 though.
Could you help me to resolve the issue?
Thanks

[Flag_Hippo]

I am having the same problem, I am using postgreSQL 16 though.
Could you help me to resolve the issue?

If you haven't already done so and don't have a large database then click the 'Housekeeping' button and run the following in this order:

1. Reindex
2. Cluster
3. Vacuum/Analyze

After the housekeeping is complete 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 your issue 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 follow up with you:

Tutorial: Reporting A Problem