PDA

View Full Version : External HDD ?!



Ptrckolous
11-29-2009, 08:36 PM
Hello

Since my Harddrive is about to get full, I'm thinking about buying an external HDD (1TB or something like that) to keep all my stuff vom Holdem Manager (Imported Hands,...) on this external HDD to safe some space on my harddrive. Is it possible to keep Holdem Manager still working on an external HDD or will there be some issues with PostgreSQL or something like that (I don't know maybe HM can't work without it and so I have to install it on the external HDD as well)?

Thanks

fozzy71
11-29-2009, 10:42 PM
Your DB is usually what takes up the most space. You can free up a lot of space by deleting logs, probably. If you still need to move some data, you can move the \data folder to the external drive and leave HM and Postgresql installed to the C drive.

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



Logging:

I would suggest you turn off logging on your new SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips


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.

If you plan to have more hands in your database, and fear you might run out of space, you could move the postgresql installation to a different partition/drive:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101

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