Top 10: HEM performance increase tips - Page 2
Page 2 of 64 FirstFirst 12341252 ... LastLast
Results 11 to 20 of 635
  1. #11
    Senior Member stretch00's Avatar
    Join Date
    Sep 2008
    Location
    LAG'tard HELL
    Posts
    556

    Default

    Quote Originally Posted by mug3n View Post
    Okay, question. In the dump/restore instructions, how do you login as pmx and do all that command jargon? Anyone?
    As far as I can tell from this post,MUG
    You can just use PGAdmin to accomplish a dump/restore,but before dumping you need to make a back up of that DB and store it somewhere outside of SQL.
    That link that refers to dump/restore is quite old 2006!So like I said in previous posts I am very careful about following outdated info like that!

  2. #12
    Junior Member
    Join Date
    Apr 2009
    Posts
    6

    Default

    Ohhh okay. Yeah that makes sense. I figured there has to be an easier way than entering all that stuff lol. Thanks.

  3. #13
    Senior Member stretch00's Avatar
    Join Date
    Sep 2008
    Location
    LAG'tard HELL
    Posts
    556

    Default

    I've been doing some research on sql the past day or so.And from what i can tell it really wont matter soon to do alot of the sql performance stuff with the newest version soon to be a full release,it's in a stable beta version now.So I would hold off if you can and wait for 8.4

  4. #14
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Quote Originally Posted by morny View Post
    Thanks for this, were updating the FAQs at the moment so ill give this a few days and see if theres any more suggestions and ill forward it to the guy we have updating the FAQ, if it drops down over the next week feel free to bump it to remind me to add it

    bump... what is the status of the updated FAQs?

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

    Default

    They are still being worked on. Morny no longer works for HM. I have taken over his forum responsibilities, and I believe Mike has taken on the bulk of the responsibility for the FAQs. I am starting work on re-writing one of them now, to try and lighten Mike's load. I have no way of knowing an ETA at this point. Mike might be better informed, but not sure if he could give an accurate ETA either yet.

  6. #16
    Member
    Join Date
    May 2009
    Posts
    46

    Default

    Curious how often should someone do these to free up space?

  7. #17
    Junior Member
    Join Date
    Dec 2008
    Posts
    22

    Default

    I'm really confused how to do the vacuum and stuff. It keeps saying to do these commands...but where/how? Do you just login to postgreSQL? If so how do you do that?

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

    Default

    Quote Originally Posted by All Apologies View Post
    Curious how often should someone do these to free up space?
    I do maintenance once a month at least.

    Quote Originally Posted by pr0wler View Post
    I'm really confused how to do the vacuum and stuff. It keeps saying to do these commands...but where/how? Do you just login to postgreSQL? If so how do you do that?
    Click the link where it says 'how to do a manual Vacuum'.

    Quote Originally Posted by Patvs View Post
    ..............

    -8 How to optimize the database size in 3 steps: -1 Vacuum, -2 Reindex, -3 dump/restore
    --8.1 VACUUM: VACUUM Analyse your database regularly (How to do a manual VACUUM)
    --8.2 REINDEX (see 8.1 for instructions, but choose Reindex instead of Vacuum in pgAdmin)
    --8.3 Dump/restore (for advanced users) Step by step how to dump/restore the database
    .....

  9. #19
    Junior Member
    Join Date
    Jan 2009
    Posts
    23

    Default

    Got a question about the solid states,
    The solid state disks are dropping in price now, so it's a nice option.

    The space on them is limited, so which program would you put on the ssd?
    - PostgresSQL + underlying files
    - HoldemManager root map (I noticed it's big)
    - Operating system
    - HH archive (the location to which HEM writes the files after importing).

    Where does the SSD contribute most? (assuming 80 / 120GB)

  10. #20
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    I recommend to put only the Postgresql data folder (the cluster) to the SSD. Leave the rest on a ordinary harddisk

Similar Threads

  1. Tips for Importing Large Databases?
    By cyberrico in forum Manager General
    Replies: 70
    Last Post: 12-04-2010, 02:32 PM
  2. Does purging hand increase the performance of the HUD?
    By madskills in forum Manager General
    Replies: 3
    Last Post: 06-02-2009, 01:09 PM
  3. Will Dual/Quad Core increase the speed/performance of HEM+Postgre?
    By lovetoplaypoker in forum Manager General
    Replies: 3
    Last Post: 05-08-2009, 07:08 PM
  4. Cluster postgres database to increase performance?
    By e306 in forum Manager General
    Replies: 5
    Last Post: 10-30-2008, 01:04 AM

Posting Permissions

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