PT db size
My pokertracker program is now 5,490mb big... getting to be sloooooooooooow... is this normal? Anyway to get this compacted? any advice?
|
Re: PT db size
do you "vacuum Full/ Analyze" it regularly ??
I do that, then defrag my hard drive about once a week... |
Re: PT db size
yea i do maybe i will try again tonight with the defrag too, thanks
|
Re: PT db size
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. |
All times are GMT -4. The time now is 09:51 AM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.