PDA

View Full Version : Vacuum Analyze Database Doesn't Work



lolothebunny
08-29-2008, 10:16 PM
Hello,
So I just bought HEM and inputted about 120k HH. I then set up the HUD for different tables/etc and played a few games. The HUD usually takes about 10 hands before it loads, so I decided to vacuum analyze the database to hopefully make it load quicker.

When I click Vacuum Analyze Database and click yes to the prompt that it may take awhile I then get the error, "There was an error during the Vacuum. Please manually vacuum your database through pgadmin."

First I was wondering how to fix the error and second I was wondering how to manually vacuum the database using PGadmin.

Thanks

fabio
08-30-2008, 09:25 AM
Hi,

please use this guide to navigate through pgAdmin but click on maintenance and not backup (last screen)

http://208.109.95.123/faq/?f=12