vacuum the DB every night

diff --git a/plc.d/crond b/plc.d/crond
index 5bb5ba7..5fb4120 100755 (executable)
--- a/plc.d/crond
+++ b/plc.d/crond
@@ -7,7 +7,7 @@
 # Mark Huang <mlhuang@cs.princeton.edu>
 # Copyright (C) 2006 The Trustees of Princeton University
 #
-# $Id: crond,v 1.1 2006/04/06 21:51:59 mlhuang Exp $
+# $Id: crond,v 1.2 2006/04/25 21:18:19 mlhuang Exp $
 #
 
 # Source function library and configuration
@@ -34,6 +34,7 @@ HOME=/
 */5 * * * * root gen-slices-xml-05.py
 */15 * * * * root gen-sites-xml.py
 */15 * * * * root gen-static-content.py
+5 5 * * * root vacuumdb -U postgres --all --analyze --quiet
 EOF
 
         # Run them once at startup
@@ -43,6 +44,8 @@ EOF
        check
        gen-static-content.py
        check
+       vacuumdb -U postgres --all --analyze --quiet
+       check
 
        plc_daemon crond
        check