Thread: PT db size
View Single Post
  #4  
Old 11-29-2007, 03:49 AM
DrewOnTilt DrewOnTilt is offline
Senior Member
 
Join Date: Nov 2003
Location: You talkin\' to me?
Posts: 3,054
Default 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.
Reply With Quote