PDA

View Full Version : Database is getting too big!!!



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?

netsrak
10-10-2009, 09:49 AM
* Delete all files in the folder data\pg_log
* Run and complete the vacuum/full process via pgadmin. This will take a lot of time especially for 7 Million hands.
* Run a reindex via pgadmin (you find it in the vacuum options too)
* Stop all Postgresql Services and defrag your harddisk.