From 07cb20bec23644707ec7ef67e8dec5cb06aa6e83 Mon Sep 17 00:00:00 2001 From: Joerg Jaspert Date: Sun, 20 Apr 2008 20:56:09 +0000 Subject: [PATCH] Disable unneeded vacuum runs --- config/debian/cron.daily | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/config/debian/cron.daily b/config/debian/cron.daily index ea84417d..215bdb59 100755 --- a/config/debian/cron.daily +++ b/config/debian/cron.daily @@ -154,10 +154,14 @@ pg_dump projectb > $POSTDUMP ################################################################################ -TS=$(($TS+1)); echo Archive maintenance timestamp $TS: $(date +%X) +#TS=$(($TS+1)); echo Archive maintenance timestamp $TS: $(date +%X) # Vacuum the database -echo "VACUUM; VACUUM ANALYZE;" | psql projectb 2>&1 | grep -v "^NOTICE: Skipping.*only table owner can VACUUM it$" +# (JJ, 20-04-2008) disabled, as we have autovacuum set to on in postgres. +# refer to http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM +# which says "Beginning in PostgreSQL 8.1, there is an optional feature called autovacuum, +# whose purpose is to automate the execution of VACUUM and ANALYZE commands." +# echo "VACUUM; VACUUM ANALYZE;" | psql projectb 2>&1 | grep -v "^NOTICE: Skipping.*only table owner can VACUUM it$" ################################################################################ -- 2.39.5