should we have multiple databases?

[omaha]

I data mine quite heavily, so have very large database.

My main problem is the amount of time it takes to cluster and analyse a large database.

Am I am high best to start multiple databases at each site?

If so, is it possible to have the hands automatically placed into the correct database? Also, can we separate six Max from full ring?

[APerfect10]

** Moved to PokerTracker 3 - General Forum **

I would recommend only have two databases. One for observed hand histories and one for played hands. I would not separate them by site, at least played hands. You could separate observed hands by site...

I definitely would not separate them by limit.

FWIW, Importing on a site by site basis is currently not supported. Once enabled, under your site configuration tab in the Auto Import window, you would need to check 'Override Defaults' then select the appropriate database(s).

Best regards,

Derek

[_dave_]

FWIW, you will greatly decrease your clustering time (and speed up most every other aspect too) if you purchase a new hard disk (or re-task an existing one), create a partition big enough to hold all your database (at least 3* expected max size) and use the TABLESPACE trick to store the database on it. Do not put any other data on this partition, only pg_data.

[Qaarc]

sorry to hijack this thread ... but it was mentioned here

Can I export using the following creteria

One for observed hand histories and one for played hands

I have combined them, beforing understand the implications and now hope fully want to seperate them

[Josh]

There's no way to selectively purge or export right now, though this is coming.

[Qaarc]

is this functionality in PT2?

I will just wait till it is available. Thank you.

[Josh]

Yes, you can selectively export/purge from PT2.

[omaha]

What is the TABLESPACE trick?

I have just bought a new drive, and will be configuring it as above! Great minds must think alike!

[_dave_]

it is in the general/PostgresQL forum, OP by me. EDIT: OP not by me, link here: viewtopic.php?f=17&t=526

most important is to make a TABLESPACE on a partition all of it's own, so no other windows cruft gets in the way of the database filesystem.

[omaha]

Thanks, i tried it, but cant get my folder to be shared. I am using xp, have posted more info in your linky