Hi Fozz

Firstly, thank you for the advice/link re: population tendancies. Poker data porn, that! :-)

I'm wondering if my DB back up times are normal, and/or if can/should do anything about it? DB is 11Gb (I think it might be a bit less now after some maintenance, but lets go with 11Gb). It takes 20 to 30 minutes to do a full Vac - I just run it and come back and it is done, not bothered by this, and I do it every other day or so. When I do a back up it takes hours, at least 4 maybe 5. Is that about right? Would I be better to do a back up in PGAdmin, and if so is there anything to know?

Does DB management (and operation) speed become impacted the more you create new ones and swap around? I think (but could be placebo) that the speeds worsened since playing around and switching between different DB's to analyse data.

In the background t this I am currently speccing a new machine out with SSD in order to use NC - will that impact backup speed in a meaningful way? Current spec is 250Gb SSD 16gb Ram and i7 CPU (probably 4th gen - just looking into that ). If there is anything that would help with speed I'd be grateful to know now before I commit.

I know that is a lot of questions, really I want to know if my DB backup time is the norm for its size, if PGAdmin is a better tool to use and if I should incorporate anything into a new 'puter build whilst I am at it.

Thanks

LET

Is the 11gb what shows in the HM2 database manager? If so, in reality it is likely closer to 20gb as that database info tab only counts the postgresql \data folder and not the users directory \database folder under Holdem Manager. If you have a HDD right now that time sounds about right, especially if it is a slower 5400rpm HDD.

Switching from DB to DB should not affect your backup (or maintenance) times. Backing up via PGAdmin (then manually backing up the users \database folder via zip + copy/paste) is a bit more complicated (and even more complicated when you go to restore it from a manual backup) and shouldn't be any faster as all HM2 does is call on those pgadmin commands to backup the \data folder and then add in the users \database folder so the backup can all be contained in a single file instead of being a pg dump + a backup/zip of the users \database folder. Here are instructions for backing up via pgadmin if you want to give it a try.

I just backed up a 1600mb database (1mil cash hands) according to HM2's Database Info using the HM2 Database Manager on my PC (6 year old Ci7-920, 9gb RAM with a couple year old Samsung 256gb SSD) and it took me about 15 minutes so an 11gb db would take me ~100 minutes on my machine.

Fozzy71
Customer Support

Thanks, that's helpful. It does raise a different point, though:

I have circa 1-2M odd hands (mostly from Stars), and I show 11gb, yet you show a much smaller DB size for circa the same amount. Is there something that I am not doing to keep DB size down?

I recall re-importing historical hands after losing a DB, and I wonder if I have duplicate entries. How would I check for duplicity. They don't appear in the normal display on 'reports' tab etc.

LET

This is a cash hands only DB I recently made via manual import for testing purposes and I disabled NoteCaddy note creation. Tournament hands (and results), player/hand notes, notecaddy notes, age of the database, auto-importing, etc can all make a database bigger. All you can due short of recreating it from scratch via backup and restore or manual import to a new database is what you have been doing via the maintenance.

Fozzy71
Customer Support

Is this issue already solved?

The assigned internal ticket # on this issue is HM-7671: Improve alignment of HUD Stats with no sample when using 'Always use 2 digits' option


A grid like the popup grids would be appreciated.

I can not click the "t" seperator. It is locked.
https://gyazo.com/929b0f01b1259b79a90aa8247d3d4a10


Ty

No, and it likely won't be at this point as our focus is on HM3 now so HM2 is only receiving critical bug fixes going forward and not new features.

This is because you your HUD has the HUD Settings > General Settings > Common Settings > [x] 'Show Abbreviations' option enabled. You can't use a separator when you have that option enabled.

Fozzy71
Customer Support

That option with "t" works fine if you use some spaces here and there, and clicking show abbrivations after you select the "t".
Thanks.

Thank you for letting me know your workaround method as it has been quite a while since this question was asked or I tested out the workarounds. This will be much easier to do with HM3.

Fozzy71
Customer Support

Hello, there is a problem with my HUD recently. HUD work fine until I click to activate that table or when the table is activated as it is my turn to act, then all the HUD on that activated table all dissappear. then after quite a while, HUD would come back.

This is troublesome, because the time table is activated is exactly when I need the HUD to consider fold raise call etc.

Another thing is recently when I start HM2, it often stuck somewhere, I don't know, perhaps importing hand history? Then I cannot close it, and had to use task manager to terminate the HM2 process. When I start HM2 again, it is usually fine.

Thank you in advance for your help.

Which site/games are you playing?

Please see this FAQ to alleviate any security bottlenecks.

Please give HoldemManager and your site(s) Administrator rights.

Make sure Windows Aero and Desktop Composition are enabled.

For this problem, and if the steps I posted above don't solve your HUD problem, we will need to see some log files to determine a cause and provide a solution. Please reproduce the problem and send your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

Fozzy71
Customer Support

i tried the fine tine option in hem with relation to postgres

and now hem doesnt connect to postgres, when i press retry connection, it says: cant connect to postgresql (wrong server, port, or firewall enabled?).

is it possible this fine tune did something (like change the password) and thats why i cant connect ??

It wouldn't have changed the password but this happens occasionally.

Use Windows Explorer and browse to C:\Program Files\PostgreSQL\X.x\Data and rename postgresql.conf to any other file name you like, then rename postgresql.conf.hembak to postgresql.conf and try to restart the postgresql service (type 'services' into your Windows Start menu search to open the Services window).

If you can't see the extension, turn off the windows option that is hiding that extension.

Once you get the old conf file working I would suggest you try tuning it manually. First make sure you copy/paste the original so you have another backup of it before you make any edits.

Fozzy71
Customer Support

Thanks. It is a bit complicated. I will send the log file to HM support to see if solving the second problem takes care of the first problem. Honestly it seem rather complicated to me how to solve the first part. The only site/game I play is Pokerstars NLHE. Everything was fine until a few days ago.

I thought about it then realize there is a lazy way out. So I uninstall the several program in that time span, turns out it work fine now. perhaps the McAfee was causing the problem. several days ago when I was surfing the internet, I was prompted to install adobe Flash player. but later I found out the installation includes McAfee and intel true key etc. IDK which one was causing the problem. I uninstall them all, and HM2 HUD is fine now. very happy about that. Anyways, thanks a lot. if I did not ask I would not have realized it is my PC's problem.

Thank you for letting us know what solved your problems.

If you had sent us logs and we saw you had McAffee installed that would have been one of our suggestions, to uninstall it. It, and many/most of the other popular free antivirus programs, can cause all sorts of problems with the HUD and database.

Good luck at the tables. If you have any further questions or problems do not hesitate to ask us.

Fozzy71
Customer Support

my hud stopped working when playing tournaments on partypoker (bwin). cashgames still works fine. Anyone having the same issue?

fixed it. sorry

when i try to mark a hand while playing by clicking on the last winner of the pot in the box above the table....i am usually unsuccessful

it only works sometimes, very tilting

how can i fix this or find a new way to mark quickly while multi tabling

for the par 4 years ive been copy pasting the hand in a note pad and naming each hand while playing 10-ish tables...so help is much appreciated

I am trying to use HMQL queries. Is there any way to filter by the buy-in for tournaments for stats when it is a string with a euro? I want to only get tournaments where the buy in is greater than 30 euros.

Something like

select StatTotalHands, StatVPIP from stats where [SOMETHING ABOUT THE BUY IN HERE]

I've gone through the entire doc in detail and cannot figure out a solution.

Thanks!

Which site/games are you playing? Which Operating System, Firewall, and AntiVirus are you using?

You are using the right mouse button, right? Or are you left-clicking to open the Hand History Viewer then marking the hands in the Hand History Viewer?

Have you tried using the hotkeys?

Please see this FAQ to alleviate any security bottlenecks.

Please give HoldemManager and your site(s) Administrator rights.

If none of that helps try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB.

If you continue to have problems, please reproduce the problem and send your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

Fozzy71
Customer Support

I am not sure if that is possible. I will check with the developers and when they reply I will quote you again in this thread, and also PM you the answer to be sure you get it.

Fozzy71
Customer Support

Great, thank you. I do see that there is a string property in the documentation that has the tournament buy in it but nothing I try with it works.

So been long time how do you convert hands from HEM to 2+2. used to just copy and paste into converter. When I do this and hit convert nothing happens

I will reply to your duplicate post in the converter thread.

Fozzy71
Customer Support

it worked, thank you!!!

also...in the past few months HM2 became very slow while browsing reports and stuff like that

if i want to refresh or view a report it takes 4-6minutes for it to finish/refresh

i made a new DB with just 800k hands and its still that slow

http://prntscr.com/ei46o7

thats my PC....it should be way faster than 5-ish minutes right?

thanks again in advance

Assuming you have a SSD yes, it should be faster for sure and even with a 7200rpm it shouldn't take that long but I have been using a SSD for so long I forget how fast/slow a DB that size would be with a HDD. I do have an older laptop with a 5400rpm HDD but haven't done any HM2 performance testing on it a few years.

If you continue to have problems please enable the Settings > Feature Logging > [x] 'ReportStats' option and increase the Max number of log files option to 10 so old logs are saved with date/time stamps.

You can also enable this before you launch HM2 from the Start Menu.

Please reproduce the problem and attach your \HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

Please zip and email the requested file via the 'Contact Support' link with a link to this thread and your forum name.

Fozzy71
Customer Support