yesright
09-02-2009, 01:18 PM
I have used the purging hands feature to remove a sunstantial number of hands from my database.
The number of players in the database has not gone down.
How do you remove players who have zero hands (or few hands) in the DB?
fozzy71
09-02-2009, 02:15 PM
The only way currently, until the Cache Rebuilder is implemented, is a long and tedious process. If you happen to be reformatting, or upgrading to postgresql 8.4 from 8.2/8.3, those would be good times to do something like this.
Purge all hands and all observed hands:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=152
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=107
Export all your hands:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
Create a new DB:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
Import the hands previously exported. Make sure you have turned off logging for Postgresql. If you need instructions, just ask.
Delete the old DB:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21
After all of that I would suggest you do a full round of maintenance: Full/Vacuum/Analyze, Reindex, Stop postgresql Service, Defrag, Reboot.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.