Purging help

[chuckk]

I am using advanced purge to delete hands over 6 months old. I am trying to free up some hard drive space, however when purge completes I do not get any extra space on my hard drive.
FYI... I have purged over 3 million hands without any increase in hard drive space. and all of these hands had the hand histories stored. Is the purge also deleting the hand histories?

Please advise,

thanks,

Chuck

[ptrack pat]

Are you compacting the database (Access) or doing a FULL vacuum/analyze (PostgreSQL) after you do this? If not, you need to be.

The advanced purge doesn't touch the hand histories.

[chuckk]

[quote="ptrack pat"mhx]

The advanced purge doesn't touch the hand histories.[/quotemhx]

How do I delete the Hand histories?

[ptrack pat]

There isn't a way to do this in PT. Are you using an Access or PostgreSQL database?

[chuckk]

[quote="ptrack pat"c81]There isn't a way to do this in PT. Are you using an Access or PostgreSQL database?[/quotec81]


PostgreSQL database

[ptrack pat]

Use the Utilities > PostgreSQL Database Functions window to do a backup of this database. Let me know the size of the .backup file that gets created.

[chuckk]

[quote="ptrack pat"75a]Use the Utilities > PostgreSQL Database Functions window to do a backup of this database. Let me know the size of the .backup file that gets created.[/quote75a]


I created the backup file and it is 2.48 gigs. It contains the last 6 months of datamined hands.

[ptrack pat]

Wow, that's huge. Did you do a full vacuum analyze on it first?

I will PM you with directions on how to send that file to me and I'll run a SQL script to purge from the hand histories table those hands that no longer exist and send it back to you.