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.19.2.2 -r1.19.2.3 --- openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 12 Dec 2010 00:07:02 -0000 1.19.2.2 +++ openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 12 Dec 2010 01:37:24 -0000 1.19.2.3 @@ -1,14 +1,7 @@ -<<<<<<< install-next-nightly-vacuum.html - -Vacuum Postgres nightly
Alex logo
Prev Chapter 7. Database Management 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 -======= -Vacuum Postgres nightly

Alex logo
Prev Chapter 7. Database Management Next

Vacuum Postgres nightly

+Vacuum Postgres nightly

Alex logo
Prev Chapter 7. Database Management 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 ->>>>>>> 1.21 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 @@ -23,8 +16,4 @@ step.

Edit your crontab:

[joeuser ~]$ crontab -e

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

-<<<<<<< install-next-nightly-vacuum.html
 0 1 * * * /usr/local/pgsql/bin/vacuumdb $OPENACS_SERVICE_NAME
($Id$)
Prev Home Next
Deleting a tablespace Up Chapter 8. Backup and Recovery
docs@openacs.org
View comments on this page at openacs.org
-======= -0 1 * * * /usr/local/pgsql/bin/vacuumdb $OPENACS_SERVICE_NAME
($Id$)
Prev Home Next
Deleting a tablespace Up Appendix A. Install Red Hat 8/9
docs@openacs.org
View comments on this page at openacs.org
->>>>>>> 1.21