PT db size

AZDezertRat · #1 11-29-2007, 12:50 AM

My pokertracker program is now 5,490mb big... getting to be sloooooooooooow... is this normal? Anyway to get this compacted? any advice?

orentha · #2 11-29-2007, 01:10 AM

do you "vacuum Full/ Analyze" it regularly ??

I do that, then defrag my hard drive about once a week...

AZDezertRat · #3 11-29-2007, 01:47 AM

yea i do maybe i will try again tonight with the defrag too, thanks

DrewOnTilt · #4 11-29-2007, 03:49 AM

You should also cluster your PSQL databases on a regular basis (see this thread over at the PT forums for instructions).

Run vacuum /analyze
Cluster your PSQL databases
Defrag hard drive

The Cluster operation does not reduce the size of the database, but orders the records so that they are more easily retrieved during the common queries that are run by PT, PAHUD, etc.