PDA

View Full Version : Purge freed up no space



ronin222
06-20-2009, 12:31 AM
I just purged 300,000 hands from my DB but when it went to vacuum the DB, the DOS window popped up for 5 seconds then said the process was done. Should the vacuum have been that fast? It also showed no gains in freeing up disk space on my c:drive . Is something amiss?

fabio
06-20-2009, 09:37 AM
Try a manual vacuum: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163

ronin222
06-20-2009, 12:50 PM
Just did a manual vacumm and still got less than a 1/3 a gig freed up. Any other suggestions to free up more memory?

fozzy71
06-20-2009, 05:59 PM
Delete the SQL Log files located in: C:\Program Files\PostgreSQL 8.x\data\pg_log

Antny
10-25-2009, 02:54 PM
I just did the same (manual vacuum and analyze) after purging a decent amount of hands and it did not free up any space.
Deleting the stuff in the pg_log has nothing to do with this issue even though you gain space.

Any other suggestions?

fozzy71
10-25-2009, 03:59 PM
I purged my entire DB a couple weeks ago by deselecting my alias on the purge tab. When I ran a vacuum, it went from 1.6gb to about 700mb.