Index: openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html,v
diff -u -r1.23.2.10 -r1.23.2.11
--- openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 21 Jun 2016 07:44:36 -0000 1.23.2.10
+++ openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 23 Jun 2016 08:32:45 -0000 1.23.2.11
@@ -8,12 +8,12 @@
data can make a tremendous difference in the execution speed of
queries. This command can also be run from cron, but it probably makes
more sense to run this command as part of your nightly backup
- procedure - if "vacuum" is going to screw up the database, you'd
- prefer it to happen immediately after (not before!) you've made a
+ procedure - if "vacuum" is going to screw up the database, you'd
+ 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
+ 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.
- Edit your crontab:
[joeuser ~]$ crontab -e
We'll set vacuum up to run nightly at 1 AM. Add the following
+
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 $OPENACS_SERVICE_NAME
($Id$)
View comments on this page at openacs.org