View Full Version : doing a vacuum
leoslayer
01-18-2011, 08:06 PM
if i use the auto vacuum in the program will it change the stats i have on players? i want to free up some space but i dont want to change stats. also the video in the knowledge base dose not work for this function.
Patvs
01-19-2011, 05:18 AM
Vacuum/Analyse/Reindex will have NO influence on your stats.
They all only do something similar to defragging a harddisk.
Making the database more "compact" and putting data that belongs together closer to each other--> so more efficient and faster queries/searches can be run.
leoslayer
01-19-2011, 12:42 PM
ok so if i want to purge hands i can do that without messing up the stats as well correct? is there a video on how to do that?
Patvs
01-19-2011, 10:07 PM
Purging: use options---> settings--> observed HH Configuration--> Purge hands-->
That way you'll lose the ability to replay the hand. But you'll keep all the stats.
It'll only save you about 10% of diskspace. Really not a lot.... so read
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html
and check out other things (turning off logging, etc.) first
leoslayer
01-19-2011, 11:07 PM
logging is off but my hard disk is almost half full. so i was thinking bout cleaning it out a little
leoslayer
01-20-2011, 02:27 AM
i cant get it to work every time i try. the whole program freezes. even if i only try to do 1 months hands at a time
netsrak
01-20-2011, 04:52 AM
Please try to purge only 1 day. Sometimes the purge has problems with larger amounts.
If 1 day works you can try to purge larger periods.
leoslayer
01-20-2011, 12:20 PM
ok ill try it that way
leoslayer
01-21-2011, 04:47 AM
well the purge was not going well so i fig i would vacuum and optimize.
that did not go well either got error 57014. something about request stopped by user? i cant remember but that was the code. can u help me with this?
Patvs
01-21-2011, 06:51 AM
Manually vacuum/analyse/reindex the database in pgadminIII, so NOT using the optimization tool in HoldemManager.
Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html
leoslayer
01-22-2011, 04:39 PM
ok i did the manual vacuum and it seemed pretty quick. dose it really only take a few mins or did i close it out too quick? is there a reason after i did the manual one that the auto one still dose not work?
leoslayer
01-22-2011, 04:54 PM
should postgres.exe show up 5 times in task mgr even though hem is not running?
leoslayer
01-22-2011, 05:40 PM
actually it showed up 7 times while 1 tabln
Patvs
01-22-2011, 08:01 PM
ok i did the manual vacuum and it seemed pretty quick. dose it really only take a few mins or did i close it out too quick? is there a reason after i did the manual one that the auto one still dose not work?
Postgres.exe showing up 5+ times is normal.
The optimization tool often doesn't work: if you don't use SQL 8.4, or have it installed to a non-default installation folder (or not on C:/)
Just use pgadminIII instead.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.