PDA

View Full Version : Manually vacuuming



Manhat10ite
11-30-2009, 12:41 AM
This link is coming across as gibberish in both Explorer and Chrome. I just imported about 2 million of my hands and thought it would be a good idea to vacuum the DB. I am told to do it manually. Can you please post the steps clearly for a computer noob.

http://www.holdemmanager.com/downloads/ManualVacuum.doc

_Loki_
11-30-2009, 02:27 AM
This link is coming across as gibberish in both Explorer and Chrome. I just imported about 2 million of my hands and thought it would be a good idea to vacuum the DB. I am told to do it manually. Can you please post the steps clearly for a computer noob.

http://www.holdemmanager.com/downloads/ManualVacuum.doc


The link downloads this (the original had pictures) :

Go to Start > All Programs > PostgreSQL 8.2 > PG Admin III or you can navigate to the .exe file by going to C:\Program Files\PostgreSQL\8.2\bin\ and click on the elephant icon


<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 class=inlineimg title="Stick Out Tongue" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" src="images/smilies/tongue.gif" smilieid="5" alt="" border="0" v:shapetype o<>Double click on “PostgreSQL Database Server 8.2” in the object browser window in the top left and it will prompt you for your password. This is your password that you used when setting up PostgreSQL. </v:shapetype>
<v:shapetype class=inlineimg title="Stick Out Tongue" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" src="images/smilies/tongue.gif" smilieid="5" alt="" border="0" v:shapetype o<></v:shapetype>
<v:shapetype class=inlineimg title="Stick Out Tongue" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" src="images/smilies/tongue.gif" smilieid="5" alt="" border="0" v:shapetype o<>You then need to expand the database folder and choose the applicable database (HoldemManager by default). It may bring up a popup window about database encoding and if so click on “don’t show this tip again and just click ok. The right click on the applicable database which will bring up a pop up and choose the “Maintenance” option</v:shapetype>
<v:shapetype class=inlineimg title="Stick Out Tongue" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" src="images/smilies/tongue.gif" smilieid="5" alt="" border="0" v:shapetype o<></O:p
This will bring up the maintenance screen and make sure that Vacuum and Analyze and possibly full are selected and select OK
</v:shapetype>

fozzy71
11-30-2009, 11:10 AM
That FAQ was in need of being converted to HTML from the .DOC form.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163