Optimize PostgreSQL with vacuum

To optimize your PostgreSQL database, run a built-in utility called "vacuum."

Normal use of database software often creates data overhead that needs to be
cleaned periodically in order to ensure optimal speed and stability. This overhead is
usually the result of temporary files and indexes that the database creates (analogous
to a fragmented hard disk.)

The vacuum utility runs on a live database and, like the
backup command, can be scripted to run nightly or at minimal server load times.

To vacuum the CollabNetTeamForge database, run the
vacuum command as the PostgreSQL user.