PDA

View Full Version : database too big?



nxtwrldchamp
11-20-2008, 06:45 PM
i am constantly running low on available disk space for my C drive. The postgresql folder is almost 12 GB and I was wondering if there was a way to compact my database... or anything I can do to make it smaller?

nxtwrldchamp
11-20-2008, 06:47 PM
will Vacuum Analyze do the trick?

nxtwrldchamp
11-20-2008, 07:03 PM
said i needed to do it manually...

are these the steps?

1) Open pgadmin from your start menu in windows under postgresql
2) Double click on the server name and enter your postgresql password (default is postgrespass)
3) Click on Databases and select the current database
4) Right click and go to Maintenance and then Vacuum and select Full and Analyze

Al1
11-20-2008, 07:52 PM
Hi,

Manually Vacuum:
http://208.109.95.123/faq/afmviewfaq.aspx?faqid=163

And here others tricks to improve the speed of HM:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=162