hm 2 speed problem

    • sandraardnas
      sandraardnas
      Gold
      Joined: 11.01.2012 Posts: 2,017
      Hi, I searched my hm2 looking for answers why its soo sloow. Even thou I purged every single hand both cash and tournamets database info shows that my database has 13 GB.
      I think I have only one database (how can I check this out?).

      So how can I remove those 13 GB of files?

      thanks
  • 3 replies
    • Alan883
      Alan883
      Bronze
      Joined: 03.12.2008 Posts: 1,941
      Before our guru Netsrak answers you i think you might want to check this link:
      HOLDEM MANAGER 2 PERFORMANCE & SPEED MODIFICATIONS.

      I think there are really a lot of very good tips how to make your HM2 faster.

      This part is i think the most interesting for you:
      PostgreSQL

      Edit PosgreSQL.conf file in the SQL C:/Program Files/8.x/data folder.
      Do not use the Tuning Wizard. On some systems it will make unecessary changes to the postgresql.conf, resulting in being unable to connect to the database!
      If this problem occurs, go to the 8.4/data folder, delete postgresql.conf. Rename the backup postgresql.conf.2009(data xxxxxxxx) to "postgresql.conf". Now reboot.

      Recommended changes:
      shared_buffers = MB (set this to 20% of your system memory, but not more than 1000 MB.... round it off to 128 MB, 256 MB, 512 MB or 768 MB)
      effective_cache_size = MB (set this to 2x the size of the shared_buffers)

      Decrease the size of the databases:
      How to optimize the database size in 3 steps: -1 Vacuum, -2 Reindex, -3 dump/restore
      VACUUM: Analyse databases regularly(How to do a manual VACUUM)
      REINDEX (see Vacuum, but choose Reindex instead of Vacuum in pgAdmin)
      Dump/restore (for advanced users) Step by step how to dump/restore the database
      How to make PostgreSQL stop making those big log files:
      http://www.holdemmanager.net/forum/showthread.php?t=8423


      I hope i found something useful for you otherwise netsrak will :D

      Good luck.
    • sandraardnas
      sandraardnas
      Gold
      Joined: 11.01.2012 Posts: 2,017
      It helped, thanks a lot.
    • Alan883
      Alan883
      Bronze
      Joined: 03.12.2008 Posts: 1,941
      That is so great. Well done sir.

      Would you be so kind and share with us what exactly you have done so we can have this for future reference.

      Thank you and i am really glad it helped.