cluster and purge

[pr1mo]

i created a new postgres database, imported many millions of hands, now i would like to cluster/vacuum/analyze and also purge out all of my hands with less than 6 players and then backup the database and copy to another pt2. is it better to do the cluster thru dos and then vacuum/analyze before or after the purge?

[ptrack pat]

Is this for PT2 or PT3? There is no cluster option in PT2 so you would have to do this from the command line.

It would be a good idea to do a full v/a before and then after the purge, it will make the purge go faster and then afterwards it will free up disk space.

[pr1mo]

yes pt2 - cluster run through dos based on these settings, are these still correct and best way to cluster?

http://www.pokertracker.com/forums/arch ... hp?t=15545

[ptrack pat]

Yes, that's right, just make sure to do a backup of your database first using the Utilities > PostgreSQL Database Functions window.