PT4 running very slow - tourneys no showing + import error

[Late Ariba]

Played a bunch of tourneys (HT-HUSNG-stars) without pt4 running.
Once finished I run pt4 to consume the hh from todays play
Afterwards I loaded my last 200 tourney summaries requested from stars + 60 or so hands played on an ipad the day before.
one of the ipad hh produce this error message

09:08:19 pm: Error: Fatal Exception: Access violation (0) (Flags: 0; Address: 0x006e65ce; EIP: 0x006E65CE)

PS PT4 was running really slow and wasn't loading any tourney results for the day after 1.19 was installed two days ago. So I did some db maintenance (reindex,tune,vacuum) but still nothing so I rebuild the cache but still not tourneys showing

====================
from the import log
09:07:26 pm: - Tournament summary imported.
09:07:26 pm: - Tournament summary imported.
09:07:26 pm: + Complete (0 hands, 0 errors, 0 duplicates)
09:07:26 pm: Import complete. 0 hands in 1 file were imported. (0 errors, 0 duplicates)
09:07:40 pm: PokerStars: Starting auto-import.
09:07:40 pm: PokerStars: Found 0 files to monitor.
09:07:41 pm: PokerStars: Stopping auto-import.
09:07:41 pm: Auto-Import stopped.
09:07:51 pm: Importing files from disk...
09:07:52 pm: Import file: C:\Users\xxxxxx\Desktop\New Text Document (2).txt
09:07:53 pm: + Complete (60 hands, 0 errors, 0 duplicates)
09:07:53 pm: PokerStars: Tournament #562913775:
09:07:53 pm: - Tournament summary re-imported.
09:07:54 pm: - STT (2 max) Super-Turbo SNG
09:07:54 pm: PokerStars: Tournament #562913214:
09:07:54 pm: - Tournament summary re-imported.
09:07:54 pm: - STT (2 max) Super-Turbo SNG
09:07:54 pm: PokerStars: Tournament #562912836:
09:07:54 pm: - Tournament summary re-imported.
09:07:54 pm: - STT (2 max) Super-Turbo SNG
09:07:54 pm: PokerStars: Tournament #562911793:
09:07:54 pm: - Tournament summary re-imported.
09:07:55 pm: - STT (2 max) Super-Turbo SNG
09:07:55 pm: PokerStars: Tournament #562909997:
09:07:55 pm: - Tournament summary re-imported.
09:07:55 pm: - STT (2 max) Super-Turbo SNG
09:07:55 pm: Import complete. 60 hands in 1 file were imported. (0 errors, 0 duplicates)
09:08:19 pm: Importing files from disk...
09:08:19 pm: Import file: C:\Users\xxxxxx\Desktop\New Text Document.txt
09:08:19 pm: + Complete (0 hands, 0 errors, 34 duplicates)
09:08:19 pm: Import complete. 0 hands in 1 file were imported. (0 errors, 34 duplicates)
09:08:19 pm: Error: Fatal Exception: Access violation (0) (Flags: 0; Address: 0x006e65ce; EIP: 0x006E65CE)

[Late Ariba]

Well shut pt4 down tried to load the hh file and its fine.

Unfortunately the db is still running very slow. When filtering for today's results its just say loading... for both the graph and results list. It goes on for quite a while and nothing happens. CPU usage by PostgreSQL went up to 95%. After 3-4 mins the result do come up and they do look correct. This is roughly 35 tournies with a few hundred hands so nothing much really.

[WhiteRider]

It shouldn't take that long to display results for that many tournaments of course.
Did you run housekeeping options after the import problems occurred? It sounds like the cache may not be updated, so if not try running it again.
Otherwise, please try creating a new database and use Get Hands From Disk to import your hands and see what the performance is like there?

If you still have delays please attach the PokerTracker4.log file from C:\Users\yourname\AppData\Local\PokerTracker 4\ (which you can access from the PT4 File menu) to a Support Ticket so that we can see what is going on.