Index: openacs-4/packages/acs-core-docs/www/database-management.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/database-management.html,v diff -u -r1.14.2.14 -r1.14.2.15 --- openacs-4/packages/acs-core-docs/www/database-management.html 11 Feb 2004 11:19:46 -0000 1.14.2.14 +++ openacs-4/packages/acs-core-docs/www/database-management.html 8 Mar 2004 21:21:45 -0000 1.14.2.15 @@ -35,8 +35,9 @@ service0.
Then, to drop the db, just do:
[service0 ~]$ dropdb service0
DROP DATABASE
- The "vacuum" command must be run periodically to reclaim space. The - "vacuum analyze" form additionally collects statistics on the + The "vacuum" command must be run periodically to reclaim space + in versions of PostgreSQL before 7.4. The "vacuum analyze" form + additionally collects statistics on the disbursion of columns in the database, which the optimizer uses when it calculates just how to execute queries. The availability of this data can make a tremendous difference in the execution speed of @@ -46,7 +47,8 @@ prefer it to happen immediately after (not before!) you've made a backup! The "vacuum" command is very reliable, but conservatism is the key to good system management. So, if you're using the export - procedure described above, you don't need to do this extra step. + procedure described above, you don't need to do this extra + step.
Edit your crontab:
[joeuser ~]$ crontab -e
We'll set vacuum up to run nightly at 1 AM. Add the following line:
0 1 * * * /usr/local/pgsql/bin/vacuumdb service0