This should perform a vacuum of the database which can take up to 30 mins
Perform at root
# ./service cscm stop
# ./service cscm start
To manually vacuum database . . .
su – postgres
(takes you to -bash-2.05$ prompt
vacuumdb -f -a
It could take a while depends on size of database, I do not know a way of monitoring this.
When it finishes carry out the stop / start above **