PDA

View Full Version : Too fast growing DataBase



defiler_pl
05-05-2013, 08:40 AM
My database is getting bigger very fast. I have 7gb free disc space, and after 3-4h playing and 3-4k hands later it's all full. I've managed to free 2,5gb and it was again filled after another 1k hands. I don't use notecaddy, I've done database vacoom. I've noticed that when I have HM2 running - the disc space is getting lower even without playing

fozzy71
05-05-2013, 12:56 PM
Make sure you are using the latest release of HM2 as it has some fixes for log files that were growing rapidly due to Zoom tables.

How big is your hard drive in total and how much space is used? If your C: drive is rather full and you want to try and clear some free space I always suggest deleting any video files you may have, as those take the most space typically. 7GB is not much free space regardless of how big your hard drive is.

This program will help you find what files are taking up the most space, visually.

WinDirStat - Windows Directory Statistics (http://windirstat.info/)


Make sure NoteCaddy is completely disabled via the HUD Options > Displayed Stats > [ ] Show Caddy Notes

Delete any existing note caddy notes via PGAdmin by opening the selected database > Schemas > Public > Tables and right-clicking and choosing Delete/Drop for the notecaddy_data table as shown in the following image:

110911

You should also delete any extra/additional databases from pgadmin that you are no longer using or any HM1 or PT3/4 databases you no longer need.


If you continue to have problems, you might want to consider moving your database to a different hard drive partition that has more overall free space - http://hm2faq.holdemmanager.com/questions/1172/Move+Database+to+Another+Hard+Drive+or+Partition