Index: openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml,v diff -u -r1.2.2.4 -r1.2.2.5 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml 15 Dec 2003 17:17:52 -0000 1.2.2.4 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml 11 Feb 2004 17:38:12 -0000 1.2.2.5 @@ -100,8 +100,9 @@ Vacuum Postgres nightly - 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 @@ -111,7 +112,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: