fischbo
10-10-2009, 07:56 AM
My HM database is now about 123 GB big. I am starting to get major disk space problems.
I have already done "Options -> Purge hands" and deleted over 7 million hands. Still, the DB wouldn`t shrink.
Then I did "Options -> Vacuum Analyze Database", which didn`t help.
Then I tried to go into the actual postgreSQL program and did a manual "vacuum full" scan, like explain in FAQ 163 http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
This scan lasted overnight and released no major diskspace, either. I quit the program after it didn`t seem to make any more progress.
Right now, the PostgreSQL folder is still about 123 GB even though the purged 7million hands should be about 1/3 of my database and therefore release about 40GB space.
Can anyone help me?
I have already done "Options -> Purge hands" and deleted over 7 million hands. Still, the DB wouldn`t shrink.
Then I did "Options -> Vacuum Analyze Database", which didn`t help.
Then I tried to go into the actual postgreSQL program and did a manual "vacuum full" scan, like explain in FAQ 163 http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
This scan lasted overnight and released no major diskspace, either. I quit the program after it didn`t seem to make any more progress.
Right now, the PostgreSQL folder is still about 123 GB even though the purged 7million hands should be about 1/3 of my database and therefore release about 40GB space.
Can anyone help me?