downloading all hands from stars 2009, tips?

[mikey]

Hey fellas I requested all hands I've played from 2009, which were sent to me in 8 files from stars. This is going to be a ton of hands, as I shortstacked 24 tabled quite a lot.

Any tips? Not well versed in HEM yet, after I import the hands to HEM can I delete the files stars sent me to save some space?

[fozzy71]

The hands themselves dont take a lot of room, especially when put in a zip/rar file like they send to you. I would keep all your original hands they send you as well as any \hmarchives you have already. Then if you ever need to rebuild the DB you have your hands.

Please update to the latest version - http://www.holdemmanager.net/hmupdate


Turning off logging will save you some space.

To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.



------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = off # Enable capturing of stderr and csvlog


File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.


- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.


You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin.
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=107
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
and you can delete all files in the postgresql subfolder data\pg_log.



and check the performance tips from the link in my signature.

[mikey]

Awesome, thanks Fozzy! :)