PDA

View Full Version : Cull database?



Arizona Willie
12-09-2009, 03:36 PM
Is it possible to remove hands from your database for time windows that you don't normally play?

I imported a million hands from a hand history seller and am getting 24000 per day. Most of those hands are from time frames when I don't play. I usually play between noon and 4 pm my time.

I see little reason to be keeping hands from 2 am in my database as the people who play then aren't likely to be playing when I am.

So I would like to cull all hands from my database that aren't within my time window.

Is that a good idea or am I missing some reason to maintain a database on people who play at different times than I do?

fozzy71
12-09-2009, 08:34 PM
No, this is not currently an available feature.

You can suggest it, or vote for it, here - http://holdemmanager.uservoice.com/pages/5307-holdem-manger-suggestions


You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin. This will get rid of all the hands but leave the HUD stats. After you vacuum you should stop the postgresql server and defrag.

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


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.

Arizona Willie
12-10-2009, 02:31 PM
You say that purging the database will get rid of the hands but keep the HUD stats.

Will it keep the stats used by Table Scanner?

netsrak
12-10-2009, 04:26 PM
yes