PDA

View Full Version : help me to vacuum



sergiod
07-27-2010, 12:43 PM
Hi, is the first time that i will vacuum HEM since i bought it. I try the step by step on the site but can't find the elephant icon. Hem member Loki had tried to help me but haven't been able to find the admin or the elephant icon.

http://http://forums.holdemmanager.com/manager-general/33738-hands-not-appearing-after-vacuum.html#post162485 (http://forums.holdemmanager.com/manager-general/33738-hands-not-appearing-after-vacuum.html#post162485)

any ideas would be very welcome.

thanks...

fozzy71
07-27-2010, 11:11 PM
http://www.holdemmanager.com/downloads/pgadmin3-1.10.1.zip

Unzip that and install the files in the unzipped folder.

7-Zip (http://www.7-zip.org) - free and open-source

Install it, and then Right-Click the .ZIP file > 7Zip > Extract to "FolderName\"

That will unzip it to a new folder, in the same directory, with the same name as the original zip file.

For your own use, when compressing things like hand history text files, use the default .7z compression, as it will compress at a much better rate.

How to:
Tutorial: Extracting files with 7-Zip | Binaries4all Usenet Tutorials (http://www.binaries4all.com/7zip/)

Tutorial: Extracting files with 7-Zip | Binaries4all Usenet Tutorials (http://www.binaries4all.com/7zip/extract.php)



1 - Close HM and Open PGAdmin

2 - connect to postgresql server and then to the DB. Password is postgrespass in case you ever need it.

3 - Right-Click > Maintenance on the DB.

4 - Vacuum, Analyze > OK

Wait for it to finish and change the greyed out OK button to a Done button.

Do that ever 10 -30k hands.


Every 50 - 100k hands, after finishing the steps above:

A - Right-Click > Maintenance on the DB.

B - Reindex > OK

Wait for it to finish and change the greyed out OK button to a Done button.



Next we need to Stop the PostgreSQL service so the Defragmenter can Defrag the Database.

Start > Programs > PostgreSQL 8,4 > Stop Server


Open Smart Defrag > Select both drive letter checkboxes > Analyze

Pick suggested Defrag process > Start Defrag


After Smart Defrag finishes you should restart your computer.

If you need to use HM before you restart your PC, then you need to Start Server.

Start > Programs > PostgreSQL 8,4 > Start Server



If none of that works, I would suggest a clean reinstall of a newer postgresql version:

*Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe