Note: This applies to DocuShare 6.5.x
You may optimize a PostgreSQL database by running vacuumdb. Depending on the underlying operating system, you may run vacuumdb in either a common prompt window or in a shell window while logged in either as root or as the Postgre user.
Run the command line vacuumdb -d [yourdatabase] -f -z -e, replacing the bracketed name with the name of your DocuShare database file.
Caution: To preserve your PostgreSQL indexes, do not use the PostgreSQL cluster command. Cluster will physically reorder your index information.