PDA

View Full Version : Using the dump/restore and purging hands



SuperSized
04-18-2010, 04:19 PM
I'm wanting to improve the speed of my database.

I'm not sure how to do the dump/restore. I have backed up my database, which is presumably the dump bit complete. Am I suppose to delete my database in pgadmin and then use the restore feature?

I am also having trouble with the purge hands feature. I want to keep all my hands from this year. I use the date filter to select a time before I playing poker to 31 Dec 2009 and it skips over a couple 100 000 of hands before deleting 0 hands. I have tried several times and the settings seem fine to me. Why would it not purge these hands?

SuperSized
04-18-2010, 04:32 PM
I just went through the 'Observed Hand History Configuration' and attempted to purge hands, which said it deleted 450 000 hand histories. I can still see hands from Dec 2009, which should no longer be the database ... I must be missing the obvious :confused:

Dumb question: do I just lose the ability to watch the hand in the replayer, the result of who won the hand, the pot size, hole cards etc. remain in the database?

fozzy71
04-18-2010, 05:34 PM
I'm wanting to improve the speed of my database.

I'm not sure how to do the dump/restore. I have backed up my database, which is presumably the dump bit complete.

Correct.


Am I suppose to delete my database in pgadmin and then use the restore feature?

You are following the performance tips? You may want to wait to delete the database, after you know the Restore of the .backup file has worked properly. You should definitely not delete the database until you have done a manual export/backup also. If anything happens to your database or .backup you will need the original and exported files to recreate the DB.

You need to create a new DB in PGAdmin, using the same encoding as your old DB (ASCII or UTF8). Then you can Restore the .backup file. Details are here - FAQ - Hold'em Manager Poker Tracking Software :: Backup & Restore Database (http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database)


Find and backup your \HMArchive folder. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere. To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

Export Your Notes - http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses - http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

Make sure you export any custom HUD layouts to your \Config folder and copy it for a backup. FAQ - Hold'em Manager Poker Tracking Software :: Import / Export HUD Layout (http://faq.holdemmanager.com/questions/46/Import+%7B47%7D+Export+HUD+Layout)

and finally:

Export your hands and then open the new database and import them into that - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)

Once the Hands are imported you can import the Tourney Results and Bonuses/Rakeback



I am also having trouble with the purge hands feature. I want to keep all my hands from this year.

Cash or Tourney hands?


I use the date filter to select a time before I playing poker to 31 Dec 2009 and it skips over a couple 100 000 of hands before deleting 0 hands. I have tried several times and the settings seem fine to me. Why would it not purge these hands?

Are you using the Options > Observed Hand History Configuration > Purge menu or the Options > Purge Hands menu? Try the other.


I just went through the 'Observed Hand History Configuration' and attempted to purge hands, which said it deleted 450 000 hand histories. I can still see hands from Dec 2009, which should no longer be the database ... I must be missing the obvious :confused:

Use this method - FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands (http://faq.holdemmanager.com/questions/197/Purge+Hands)

Not this one - FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands from Database (http://faq.holdemmanager.com/questions/100/Purge+Hands+from+Database)


Dumb question: do I just lose the ability to watch the hand in the replayer, the result of who won the hand, the pot size, hole cards etc. remain in the database?

The stats will remain on the Players tab and in your HUD as we do not yet have a Cache Rebuilder. They will not appear on the various other tabs like Reports and Hands.

SuperSized
04-19-2010, 03:19 AM
Ok, thanks for the advice. I rebuilt my database at the end of February, so dumping it and restoring it is probably not that useful. I will refer back to this thread when I dump and restore in a few months time.

I did manage to greatly improve the speed of the HUD stats appearing in the HUD replayer, just by purging my old hands. It went from 30 sec - 1 min to a couple of seconds :D

minifruit
08-05-2010, 09:03 PM
Hello. So HM was lagging my PC and I wanted to speed it up. Followed all the tips but I just have a quick question about this dump/restore. The article explaining this was for linux so im not clear about a few things, but will I achieve the same result on xp if i simply delete my DB via Postgres Admin, create a new one, and restore the old DB to the newly created DB? Thanks in advance for any help.

netsrak
08-06-2010, 03:35 AM
yep, thats the same procedure