View Full Version : Getting rid of old hands
Arizona Willie
02-11-2010, 01:10 PM
Is there a way to remove old hands from your database?
Say I think that hands over a year old are not very useful and I want to remove all hands over a year old both my hands and opponent hands.
Can that be done?
fozzy71
02-11-2010, 02:48 PM
options > purge hands
Regarding database maintenance:
You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin.
FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands from Database (http://faq.holdemmanager.com/questions/100/Purge+Hands+from+Database)
FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands (http://faq.holdemmanager.com/questions/197/Purge+Hands)
Then you can vacuum/analyze - FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+#manual)
Before you defragment you should stop the PostgreSQL service:
Start > Programs > PostgreSQL 8.x > Stop Server
Use your favorite defrag tool. I recommend Smart Defrag.
After defrag I recommend you reboot your PC. If you need to access the DB before rebooting you can start the PostgreSQL service.
Start > Programs > PostgreSQL 8.x > Start Server
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.