PDA

View Full Version : Question about purging hands.......?



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.