pt4 sql optimal settings

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

pt4 sql optimal settings

Postby spoutnic » Sat Jun 13, 2015 10:34 pm

Hi,

I just started to use pt4 with a coffeyay hud. When I installed pt4, I refused to have my sql settings. I had them optimised for notecaddy wich is used in my main game. But my hud pops up after a few played hands, wich I think is abnormal. I think I have to give pt4 sql configuration to have a smooth exp. I have an i5 cpu with 16gigram.

Outside the sql configuration fiIe, will pt4 change anything else when I install pt4 and accept to have pt4 optimize my sql? I plan on switching the optimised pt4 sql configuration file with the notecaddy sql optimised configuration file as demand goes. Am I missing something? If I reboot my computer after switching the file, should I enconter any problems?

Thank you for your support
spoutnic
 
Posts: 4
Joined: Tue Oct 07, 2008 4:28 am

Re: pt4 sql optimal settings

Postby Flag_Hippo » Sun Jun 14, 2015 6:02 am

That is fine. If you start PokerTracker 4 using the logging enabled link on your Start Menu and then tune PostgreSQL you can select "File --> Open User Data Folder" and open the text file called "PokerTracker4" that is in that folder. Here you will see exactly what changes were made to the postgresql.conf file.
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: pt4 sql optimal settings

Postby spoutnic » Wed Jun 17, 2015 11:55 pm

Thanks flag_hippo.

I found the sql tuning fonction and revert to old setting in database/database management/housekeeping. But, the pt4 sql tuning fonction failed.. And I have a detailed report of the fail ;)
spoutnic
 
Posts: 4
Joined: Tue Oct 07, 2008 4:28 am

Re: pt4 sql optimal settings

Postby WhiteRider » Thu Jun 18, 2015 3:01 am

Can you explain what you mean by "the pt4 sql tuning function failed"? Did you run it again after you reverted it?
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: pt4 sql optimal settings

Postby spoutnic » Thu Jun 18, 2015 5:35 pm

I got a pt4 window poping saying that the sql tuning failed the last few times I tried.

1st time I used the tuning fonction, I might have had a pt4 window saying it failed and not notice it. But I did notice 0 improvement after.. So I ran the tune sql tuning function with loggin enabled and failed, confirmed with the pt4 window popping.

I havent tried the revert function yet.
spoutnic
 
Posts: 4
Joined: Tue Oct 07, 2008 4:28 am

Re: pt4 sql optimal settings

Postby WhiteRider » Fri Jun 19, 2015 2:47 am

Please open a Support Ticket and report your problem - your log file should show us why the tuning is failing for you.
WhiteRider
Moderator
 
Posts: 53961
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 38 guests

cron