Index: openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp,v diff -u -r1.1.2.3 -r1.1.2.4 --- openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp 28 Sep 2015 07:54:19 -0000 1.1.2.3 +++ openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp 23 Jun 2016 08:32:45 -0000 1.1.2.4 @@ -9,25 +9,26 @@ rightLink="backup-recovery" rightLabel="Next">

-Vacuum Postgres nightly

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 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 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.

Edit your crontab:

+Vacuum Postgres nightly

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 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 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.

Edit your crontab:

 [joeuser ~]$ crontab -e
-

We'll set vacuum up to run nightly at 1 AM. Add the following -line:

+

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: database-maintenance.xml,v 1.8 2006/07/17 -05:38:37 torbenb Exp $)
+
($‌Id: install-next-nightly-vacuum.html,v +1.23.2.10 2016/06/21 07:44:36 gustafn Exp $)