literate-perfunctory
Poker Software
Results 1 to 2 of 2

Thread: Purged database

  1. #1
    Junior Member
    Join Date
    Jul 2018
    Posts
    1

    Default Purged database

    Hi. I purged my database of all non-hero hands from before the start of this year because I cannot use HM2 in game as it is too slow despite it running on an SSD. But it is still running too slow for me to take notes in-game: the note box takes about 4 seconds to open after I click the note icon in the HUD, and even then I cannot type properly. Meanwhile I am timing out on my tables while HM2 is being so sluggish.

    My ...\PostgreSQL\8.4\data\base folder size is 27.2GB after the purge, and my ...\Roaming\HoldemManager\Database folder size is 1.19GB.

    What is causing the problem? I will probably re-import all of those hands because the purge did absolutely nothing.

    I can provide information about my PC specifications in case it is caused by that.

    Thanks...

  2. #2
    HM2! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    18,297

    Default

    Did you analyze and vacuum the database?

    Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon)

    If you continue to have problems, try the following:

    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 - Hold'Em Manager 2 FAQs - Poker Software :: How to create a new database and import previously played hands

    If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

    Here is a FAQ explaining how to backup your database and all settings in one easy step - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work?
    Regards udbrky (Chris)

Similar Threads

  1. purged database
    By DrDunne in forum General Support
    Replies: 1
    Last Post: 03-10-2017, 03:54 PM
  2. database and purged hands?
    By prodiige in forum General Support
    Replies: 1
    Last Post: 01-07-2013, 08:29 PM
  3. How to export database w/ purged hands?
    By GiedriusZ in forum Manager General
    Replies: 1
    Last Post: 09-16-2011, 07:20 PM
  4. Replies: 2
    Last Post: 02-05-2010, 04:46 AM
  5. Purged hands - database gone...
    By Edmuntus in forum Manager General
    Replies: 1
    Last Post: 01-09-2010, 06:04 PM

Posting Permissions

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