Your postgres might be saving log files, they get out of hand quickly. Check data>pg_log folder see if there's anything there.

Good point and I see that is not mentioned in the earlier FAQ I linked to so I will add it now. Here is a FAQ about it - http://hm2faq.holdemmanager.com/ques...arge+Log+Files

Our HM2 installer will disable this by default but if he installed postgres manually or with PT4 those may be enabled.

looks like i need #2..."Make sure that PostgreSQL is not saving log files and delete them if they exist."

but it says,
"Solution:
Yes, PostgreSQL log files can become very large. Follow the steps below to eliminate the log files altogether:
Note: This is for Advanced PC Users only!!!"

im far from a advanced pc user, should i try anyway?

yeah i read on the forums i should check that file....but nothing there realy

Read thru the instructions and if you don't feel like you can do the steps safely to prevent the writing of the logs then you can just manually delete the files from the \pg_log folder every so often.

Fozzy71
Customer Support

deleting that file gave me less than 500mb

the instructions look weird near the end

i did all i could and still have less than 10gb(5%) free

postgreSQL is taking up 90gb for some reason...i have less than a million hands

http://prntscr.com/gig5g5

what now?

Earlier you showed a picture where your \postgresql folder was 90gb and in this screen shot your \base sub-folder is 70gb. That means the other \postgresql sub-folders are 20gb but that would be extreme as my other \postgresql sub-folders are less than a GB. Have you installed and used windirstat like our FAQ suggested so you can see what the other files and folders are that are using up large amounts of space?

You have 6 databases in that folder. The folder named '1' and 'psql_tmp' are default installation folders and not an actual database created by HM2 or PT4. You said you only had 2 in HM2 but how many do you have in PT4? Did you delete the PT4 databases? Apparently you have something else using PSQL besides HM2 and PT4 if their databases combined don't add up to 6.

If you go to your Windows start menu and search for PGAdmin and open it up and connect to the server it will list your databases by name instead of number. If you then click on a database name in the list on the left so it connects now to a database you will see the corresponding OID number for that database in your \base folder you posted a screen shot of.



Fozzy71
Customer Support

have asked before but couldn't find the answer after searching. How do I get cumulative for hours played(sng + mtt)?

Open the Tournaments or Tournament Results report and click the small trophy icon between the 2 report grids to see the Total Duration for the tournaments shown in the report.

Fozzy71
Customer Support

http://prntscr.com/gim6zi

so the 17gb one is pt4 and i can delete it with out effecting my HM2 db?

its very odd that my 2017 db with 305k hands is 1.6gb,
but my 2016andbeyond db with 930k hands(305k of the hands are the same ones from 2017) has 70gb

maybe i should vacuum it?
should i do full vacuum?

That is far too big for a 1mil hand database. Do you have NoteCaddy? It can cause some database bloating from the note creation process that can be reduced with a full vacuum. If a full vacuum doesn't reduce it significantly you will probably be best off to just delete it and recreate it by manually importing your 2016 and 2017 hands to the new database.

Fozzy71
Customer Support

what about deleting my pt4 database...the 17gb one...is that ok?

yes it is notecady...ill try what you said

Yes, if you do not need to have that active and/or are not using it for anything that is fine. I am not positive how their database management system works so it might be necessary to first create a new empty database before you delete that other one if it is your only PT4 database. If you have multiple databases in PT4 you can just make one of the smaller databases default/active then delete the larger one.

A vacuum of that database should reduce the size significantly. It can be done through the main HM2 Database Manager or from the NoteCaddy tab's Tools menu as well.

Fozzy71
Customer Support

i deleted the pt4 so thats nice(i never even used it)

but vacuuming helped nothing at all...still 70gb

you say i should make a new db by combining the two in to one?
this causes other problems in my notecaddy however(hm2 and nc give totaly different stats when db is larger and i dont know whos stats to look at)

anything else i can do?

You said you had a DB for 2017 and a another for 2016 and beyond so I assumed you were using the first for live play and the other for review of historical/older data. I suggested you just delete the '2016 and beyond' and create a new database and manually recreate it by importing the hands from 2016 and 2017 from your C:\HM2Archive folder. The newly created database will be much smaller than the old one, even more so if you disable NoteCaddy before you create the database or cancel the note creation process in the NoteCaddy tab after it starts when the importing finishes.

As to why you are seeing HM2 vs NC stat differences in larger databases you would have to ask their support about that in the NoteCaddy Support thread in this forum.

Fozzy71
Customer Support

http://prntscr.com/giprn5
its not letting me create a new db for some reason

If you set the 2017 database to be the active database can you create a new database?

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

same thing...i send the logs via email

will the hud in hem3 be less demanding of the cpu%?
the hudfunc is almost always at the top of big cpu-users while playing

Yes, and there is even a HUD Only mode where you can keep the auto importer and HUD processes running but have the main UI closed to use less resources and help to not distract your attention away from the tables.

Fozzy71
Customer Support

Any news on this?

Quite impressed with how HM3 handles a large db for off the table stuff, would like to get it going in-game.

Sorry, no not yet. We are a bit short-handed in the testing department this past and coming week and I can't test it myself. I will see if any of the others that can play on stars have time for testing it this weekend. If not I may have to wait until the other tester that went on vacation comes back at the end of next week.

Fozzy71
Customer Support

I restored a database after a format, but now I can't add any stats to the reports - It shows them in the "included stats" pane but it doesn't reflect on the actual report itself.

It happened before a long time ago but I can't remember how to fix it!

Edit: Creating a new database, adding a stat to a report (which worked) then going back to the prior database fixed it.