Originally Posted by
drunkkiler
Lately when i'm opening a hand in the replayers the green felt of the table appears pretty slow ,about 15,20 sec later ,or sometimes doesn't appear at all .There were a few times when the replayer window blocked .I reinstalled hm2 recently but nothing changed .I made a new db about a week ago with fewer hands (8gb vs 20gb ) and definitely had an impact(i'd say 20%-25% faster) but the replayer still blocks sometimes or the felt remains gray .
How do i reset postgresql.conf to the original state?
Did you edit it manually? If yes, you will have to revert it manually so hopefully you saved a copy of it before you made the edits so you can simply stop the PSQL service and copy/paste the old config file back in place to replace the edited one. If you didn't save a copy then you will need to use whatever instructions you used and undo each step manually.
If you used the HM2 tuning there is a restore/undo option.
If none of that works you will probably end up having to reinstall PSQL (if you do go with 9.0 or 9.2 instead of 8.4 for better performance) or have someone upload a default unedited config file for the same exact version. If you want to post your psql version number from the HM2 log file I can see if anyone on our team has the same version with an unedited default config file.
Please check your log.txt file from C:\Users\YourName\AppData\Roaming\HoldemManager. If you can't see it, turn off the windows option that is hiding that directory. http://faq.holdemmanager.com/questio...es+in+Windows+
Code:
07:52:40.407 [SetActiveDatabase:20 - PostgresqlDatabase.InitializeDatabase] [[General] ] Database Version: 9.0.18
Something else you could try to see if it helps before you consider reinstalling or reverting the config file since you have such large databases:
The default and minimum Static (ProcessWorkingSetBase) memory cap is set to 350mb and the default Dynamic (ProcessWorkingSetHandAmount) is set to 400mb per 1mil hands.
The base/static cap is set to 350mb and Dynamic cap is 400mb per 1mil hands if you don't edit the config file. These values are hard-coded into the program and are not part of the config file by default. If you want to edit these values you need to add the code below to your config file and make changes from the default values.
The base/static cap can not currently be set any lower than 350mb regardless of how you edit the config file but it can be increased above 350. The Dynamic cap per hand can be changed to 0 making it effectively a static cap or increased above 400mb per 1 mil hands if you wanted.
Before you make any changes to your config file please copy/paste a copy to your desktop as a backup: C:\Users\YourName\AppData\Roaming\HoldemManager. If your Windows is hiding known file extensions the file will simply be called 'holdemmanager'. If you can't see it, turn off the windows option that is hiding that directory. http://faq.holdemmanager.com/questio...es+in+Windows+
Leaving your config file alone is the same as putting in the following code:
PHP Code:
<Section Name="General"> <Key Name="ProcessWorkingSetBase" Value="350000000" /> <Key Name="ProcessWorkingSetHandAmount" Value="400" />
If you wanted to try smaller dynamic cap of say 200mb per 1 mil hands you would change it to:
PHP Code:
<Section Name="General"> <Key Name="ProcessWorkingSetBase" Value="350000000" /> <Key Name="ProcessWorkingSetHandAmount" Value="200" />
If you wanted to make it a static 350mb cap you would change it to this:
PHP Code:
<Section Name="General"> <Key Name="ProcessWorkingSetBase" Value="350000000" /> <Key Name="ProcessWorkingSetHandAmount" Value="000" />
Editing the first line to less than '350' would have no effect on the base/static cap.
From there you could increase the static cap to 500mb without any dynamic per hand capping by changing the config to:
PHP Code:
<Section Name="General"> <Key Name="ProcessWorkingSetBase" Value="500000000" /> <Key Name="ProcessWorkingSetHandAmount" Value="000" />
*Note:
- The upper limit for ProcessWorkingSetBase is 2100000000
- The upper limit for ProcessWorkingSetHandAmount is 840
*Another config file variable that you can try adding and editing is:
<Key Name="MaxHandsCached_Hybrid" Value="200000" />
- try values of 100000, 500000, and 1000000 and see if it makes any difference. This sets the maximum number of player hands for the current player that will be loaded. All report stats are based on these hands.
If you have any problems or make any incorrect edits to the config file you can delete the file and it will be recreated with all default values/settings. If you had any custom settings such as archive folders you can then copy them from the \Desktop copy you made earlier or just copy/paste the entire file from your \Desktop to replace the default or improperly edited file in the \HoldemManager folder.