Two Plus Two Newer Archives

Two Plus Two Newer Archives (http://archives1.twoplustwo.com/index.php)

- Software (http://archives1.twoplustwo.com/forumdisplay.php?f=47)

- - PT db size (http://archives1.twoplustwo.com/showthread.php?t=556920)

AZDezertRat

11-29-2007 12:50 AM

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?

orentha

11-29-2007 01:10 AM

Re: PT db size

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

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

AZDezertRat

11-29-2007 01:47 AM

Re: PT db size

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

DrewOnTilt

11-29-2007 03:49 AM

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 08:57 AM.