ffrllc
03-17-2009, 11:45 AM
I'm running HM v 1.08 beta 16 on Vista (as admin) and running PostgreSQL 8.2.
I have what I would consider a fairly large DB and wanted to delete some older hands to free up disc space.
I went in to the "Options" tab and clicked "Purge Hands". I then set the filter to delete all hands from all limits (I checked every limit option) prior to a date 6 months ago. I also set it to "Do not delete hands played by:" (and entered my Alias which includes my screen names from two sites.
Everything looked like the purge processed fine as it took several hours to complete. I also did the "Vacuum" after it completed the purge which also took several hours to complete, but appeared to finished without any errors.
But I still have the hands in my DB and can still access any of these old Hands that should have been purged. I can view them in the cash games tab and even replay these hands in the replayer.
Prior to the purge I checked a few things to compare with after the purge completed. Here's prior to the purge:
* 151542 players in my cash games tab
* 166GB free of 288GB on "C" Drive
* The PostgreSQL folder in my Program Files was 34.4GB's
* RVG Software folder in my Program Files was 67.7 MB's
And here were the results directly after the purge:
* The same 151542 players in my cash games tab
* 155GB free of 288GB on "C" Drive (so I actually lost 11GB's of free space on my C Drive
* The PostgreSQL folder in my program files is now 28.9GB's (this is the only one that decreased)
* RVG Software folder in my Program Files is now 78.7 MB's (grew by 11MB's)
Any idea what happened here?
How can I delete all hands (excluding mine) prior to 6 months ago?
Thanks.
I have what I would consider a fairly large DB and wanted to delete some older hands to free up disc space.
I went in to the "Options" tab and clicked "Purge Hands". I then set the filter to delete all hands from all limits (I checked every limit option) prior to a date 6 months ago. I also set it to "Do not delete hands played by:" (and entered my Alias which includes my screen names from two sites.
Everything looked like the purge processed fine as it took several hours to complete. I also did the "Vacuum" after it completed the purge which also took several hours to complete, but appeared to finished without any errors.
But I still have the hands in my DB and can still access any of these old Hands that should have been purged. I can view them in the cash games tab and even replay these hands in the replayer.
Prior to the purge I checked a few things to compare with after the purge completed. Here's prior to the purge:
* 151542 players in my cash games tab
* 166GB free of 288GB on "C" Drive
* The PostgreSQL folder in my Program Files was 34.4GB's
* RVG Software folder in my Program Files was 67.7 MB's
And here were the results directly after the purge:
* The same 151542 players in my cash games tab
* 155GB free of 288GB on "C" Drive (so I actually lost 11GB's of free space on my C Drive
* The PostgreSQL folder in my program files is now 28.9GB's (this is the only one that decreased)
* RVG Software folder in my Program Files is now 78.7 MB's (grew by 11MB's)
Any idea what happened here?
How can I delete all hands (excluding mine) prior to 6 months ago?
Thanks.