Quote:
Originally Posted by ralph cifaretto
I have HEM 1. I'm not v competent with computers. I uploaded it to my laptop. My Dad was doing a check and he said the postgre (or something) was 108 GB (yes 1 0 8) in size. Does that sound right or have i uploaded it wrongly?
Cheers
That is possible if you have multiple large databases or a single database with millions of hands.
General rule is 1 million hands = 10 GB.
In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB
It is even more likely if your postgresql installation has logging enabled.
Logging:
I would suggest you turn off logging on your new SQL installation.
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.
HTML Code:
------------------------------------------------------------------------------
# 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.
Regarding database maintenance:
You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin. You do not want to purge any Hero hands so make sure your alias is properly configured before purging.
There are two types of purges (delete)
-options--> settings--> purge hands (will delete handhistory, hand from graph, $Won from sessions, etc. everything, so hand won't be used anymore for stats)
-options--> settings--> observed HH configuration--> purge hands--> will delete the handhistory and therefore the ability to replay the hand, but the hand will still be used for the graph, $Won from sessions and for the HUD.
If you're deleting a lot of hands, it's usually best to just create a new empty database.
Then you can vacuum/analyze -
http://faq.holdemmanager.com/questio...tabase+#manual
Before you defragment you should stop the PostgreSQL service:
Start > Programs > PostgreSQL 8.x > Stop Server
Use your favorite defrag tool. I recommend Smart Defrag.
After defrag I recommend you reboot your PC. If you need to access the DB before rebooting you can start the PostgreSQL service.
Start > Programs > PostgreSQL 8.x > Start Server
