PDA

View Full Version : Hard Drive size for poker only machine



jontewks
07-13-2009, 05:34 AM
Hello!

I am going to be using a Mac running windows and as such I need to choose a size for the windows partition. I plan on only using windows for poker and keeping the database. I'm just wondering how much space to put towards windows so I can have my entire database.

How large can they get under normal use when not using a mining service?

Would a 100 gb partition be large enough?

I know it really depends on use, but I just want to get a general idea of what I am looking at.

netsrak
07-13-2009, 06:32 AM
The postgresql database will roughly need 10 GB per 1 Million hands. So i think 100 GB wil be enough.

jontewks
07-13-2009, 01:44 PM
Thank you very much.

fozzy71
07-13-2009, 01:53 PM
Make sure you turn off the logging in postgresql, as it can be a substantial portion of your SQL directory:



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
(http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613)

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.

*edit:
- 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.