PDA

View Full Version : Maintenance nr of players in database



ThePower
03-30-2009, 07:31 PM
Hello,

I have almost 75000 players in my database and would like to clean it up because it is getting too big. What I would like to do is:

1. select all players who played more than x hands
2. export all handhistories for the selected players
3. import the handhistories in a fresh new database

I know how to export and import hands but the export option so far as I know has only the possibility to export the whole database and not a data subset.

Can somebody please tell me how I can do this?

Many thanks in advance.

Al1
03-31-2009, 08:53 AM
You can't do that currently, but selectiv export will be added in the future.

Nevertheless, there is perhaps a solution for you.

Have you tried the partial purge, which delete every HHs (except your hands) but keeps the stats. After that you can vacuum and purge and you will gain some space.
Purge: http://208.109.95.123/faq/afmviewfaq.aspx?faqid=107
Vacuum: http://208.109.95.123/faq/afmviewfaq.aspx?faqid=163

You can also delete every file in the pg_log folder without issue.