PostgreSQL take a lot of space on Hard Drive
Results 1 to 6 of 6
  1. #1
    Junior Member
    Join Date
    May 2020
    Posts
    7

    Default PostgreSQL take a lot of space on Hard Drive

    Hello, i have HM2 + PostgreSQL on my C:\ drive. Drive is Kingston m.2 SSD 1TB. Ive been creating notes for 2 weeks and im at 40%. Which is good. Trouble is PostgreSQL. It takes over 400 GB and its growing up 25/30GB per day. I have serious trouble, cuz at SSD is 350 GB left so at 60% its gone Do you have recommendation how to use big databases? Im thinking about 4TB WD but ist stupid slow :/

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    You can use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller - http://support.microsoft.com/kb/251186

    You can put your postgres data folder and the HM2 database parent folder on a different drive but if you move it from a SSD to a HDD you will suffer a decrease in performance - http://hm2faq.holdemmanager.com/ques...e+or+Partition

    In HM1 there were a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise. If you don't want the space in your Roaming folder due to limited C: file space, we do give you the option of storing this data anywhere when creating the database.

    General rule is 1 million hands = 10 GB.

    In reality it's: 1 million hands
    HM1: 6.8 GB
    HM2: 4.3 GB
    PT4: 13.6 GB
    HM3: 6.0 GB

    So with a 10 million hand database you need a SSD of at least 60 GB (Windows) + 100 GB = 160 GB. We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

    Note: These numbers above are for hands only and do not account for NoteCaddy notes which will use even more space.

    We recommend you maintain more than 20% free space on your system drive. Please see this FAQ to clear up some more free space - http://hm2faq.holdemmanager.com/ques...+of+Disk+Space

    Please see these guide to optimize your SSD:

    http://www.tomshardware.com/reviews/...weak,2911.html

    http://itexpertvoice.com/home/super-...at-them-right/

  3. #3
    Junior Member
    Join Date
    May 2020
    Posts
    7

    Default

    Hi, my notes are 13 200 000/32 200 000 done. So its should be 32.2*10GBs = 322GB but my postgreSQL 422GB and still growing up. What i understand uncorrectly pls? Its gonna have over 1.1TB

  4. #4
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    How many actual hands did you import? Are these your own played hands, or are you importing mined/observed hands? I recommend you only import your own hands as playing with observed/mined hands in your database is against the rules at nearly every supported network AFAIK.

    All of those number estimates above were just for hands. They did not include estimates for NoteCaddy Notes which will require additional space in the database. The only thing I can suggest was posted above. You can try the vacuum steps (first link in the bolded line FAQ link, and below as well). The only other thing not mentioned above or in those links IIRC is that you can purge some hands and vacuum again if that does not help. If you purge hands from the database you will have to reset your notecaddy notes as well, before you vacuum, then recreate the notes in NC and vacuum again after the notes are done. You can also close HM2 during the NC note creation and vacuum the database then restart HM2 and the notes process will continue, at hopefully a higher speed.

    - Here is where you can vacuum within HM2 - https://hm2faq.holdemmanager.com/que...29#maintenance
    - Here are some more details about what those options do - https://hm2faq.holdemmanager.com/que...s+Optimization
    - And here is how you can vacuum manually with HM2 closed - https://hm2faq.holdemmanager.com/que...lyze+Database+

  5. #5
    Junior Member
    Join Date
    May 2020
    Posts
    7

    Default

    Hello, is there option to permanently stop creating notes?
    Last edited by Own; 06-08-2020 at 09:54 AM.

  6. #6
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Go to HUD Settings - HUD Editor - disable show notes at the bottom.
    Regards udbrky (Chris)

Similar Threads

  1. A lot of errors while importing hands from hard drive
    By Bleight in forum Manager General
    Replies: 1
    Last Post: 11-17-2011, 07:13 AM
  2. postgreSQL 8.3 taking a lot of my hard drive space
    By majorcrisp in forum Manager General
    Replies: 6
    Last Post: 09-18-2009, 02:42 PM
  3. Running Out Of Fusion Hard Drive Space
    By MacUser in forum Manager General
    Replies: 1
    Last Post: 06-12-2009, 07:15 AM
  4. Replies: 1
    Last Post: 03-29-2009, 09:43 AM
  5. Hard Drive Space
    By CrazyAl in forum Manager General
    Replies: 1
    Last Post: 09-06-2008, 08:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •