Page 1 of 1
Postgres Taking Too Much Hard Drive Space

Posted:
Fri Jun 06, 2008 8:19 pm
by Lucky Stiff
My 8.2 file takes up 76 GB of hard drive space which is becoming inconvenient. Is this normal? Is there a safe way to eliminate files without screwing up my DB's? I'm using PT2 until PT3 gets the HUD straightened out. My primary DB contains only 85,000 hands of my play and millions of observed hands without me playing. I do not need more than a couple of months of observed hands but they are all mixed in with my hands in the same database. Any guidance?
Re: Postgres Taking Too Much Hard Drive Space

Posted:
Fri Jun 06, 2008 8:21 pm
by ptrack pat
Use the Utilities > Database Maintenance and Options window, Advanced Purge button to purge these observed hands. You can enter date ranges and other critieria of what you want to purge.
You should do a FULL vacuum/analyze BEFORE and then AFTER you do this process to free up disk space.
Re: Postgres Taking Too Much Hard Drive Space

Posted:
Sun Jun 08, 2008 3:23 am
by Lucky Stiff
Is there a way to purge only hands in which I was not seated at the table?
Re: Postgres Taking Too Much Hard Drive Space

Posted:
Sun Jun 08, 2008 9:40 am
by ptrack pat
That's what the "Observed Hands Only" box is for on the advanced purge window. Please click the help link at the top right corner of the window for more detail.
Re: Postgres Taking Too Much Hard Drive Space

Posted:
Sun Jun 08, 2008 8:08 pm
by Lucky Stiff
I tried to do a full vacuum/analyze and, after five hours, I checked task manager to find that Poker Tracker was not responding. I ended the task and now I cannot even open PT at all--the hard drive keeps spinning but task manager shows the progam not responding. Any help?
Re: Postgres Taking Too Much Hard Drive Space

Posted:
Sun Jun 08, 2008 9:19 pm
by ptrack pat
Restart the computer.
You need to let it run, it's not PT doing this function, PT calls the PostgreSQL function to do this and with a db of that size, and if you've never done this before it's going to take a while.