PokerTracker

please excuse my ignorance. i've recently started using pt3 and my database is huge (it's taking up like 10 gig). i like to datamine a lot and realize this is probably going to keep things growing at a rate that my internal hard drive just can't handle. if i were to start a new db every month, lets say, is there a way to store my old dbs on an external harddrive (i know there must be, but i would appreciate it if you could walk me through the process). i figure i could have hud display the stats for this month and the previous month and keep all other dbs stored remotely (i assume, as in the previous version of hud, thatit can't retrieve from multiple dbs at once). can i also move my hand histories over to this external hard drive? Is this the best/only real solution to memory management?

Yes, the HUD can use multiple DBs.

What you suggest is pretty much what is recommended for large DBs and datamining.
You could set up one database for your played hands, and then import observed hands into a separate database which you change every month (or whatever). See the option on the auto-import folder for which DB to import played/observed hands into.

As for backing up databases and moving them to remote storage - backup options will be added to PT3 at some point, but for now you can do it from Postgres itself, or from the command line. There are a couple of links in the Database / Postgres FAQ.

Once the hand histories have been imported and you stop auto import, they are moved to a 'processed' folder (again, see the setting on the auto import tab). From here, you can zip/compress them and move them off to remote storage.

10 gig's no real big deal if you would like to keep it all in one place - postgres needs a fast UDMA /SATA drive though - but with careful setup we can get that running for you np, even with a dozen or more hud's running...

it's important though that you keep your [valuable] poker data backed off to a separate medium on a regular basis; again this isn't a big deal, except a 10 gig backup will take around an hour with no PT running...

we can walk you through these processes if you want...


susan