PDA

View Full Version : Deleting Hands



DcJack
11-29-2008, 12:03 PM
I want to delete some hands from 0.25/0.50 stakes totaly from the database, because as it is now my postgres map is taking up 66gb and thats to much for my computer. I tried the purge thing but the postgres map still are the same size.

morny
11-29-2008, 08:33 PM
To delete them completely make sure you followed this: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=152 after youve updated to the latest version http://www.holdemmanager.com/downloads/HmUpdate1.06.04beta.exe and when your finished run a vacuum to free up the space better: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=60

Also there can be alot of unneccessary log files that can free up tons of space in this folder: C:\Program Files\PostgreSQL\8.3\data\pg_log so you can delete these too

DcJack
11-30-2008, 09:40 AM
I did this whent to options in holdemmanager then purge hands chose NL0.25/0.50 and deleted/purged 7000000 hands then i went and did a vacuum of my database. But still my database are the same size 66gb.

morny
11-30-2008, 04:03 PM
Are the hands definetely purged? If you run a report do they show up. How many hands is in your database now? http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=19