X-Git-Url: https://dev.renevier.net/?p=syj.git;a=blobdiff_plain;f=scripts%2Fcrontab.syj;h=4dfe865ee74a69faa5db4b1e40ecdbb35c719f82;hp=78d48bee268730f9b87cf3c5722aa9d36e610a5f;hb=03f49f88786c9eefcb850927958646266f11a86d;hpb=d46d626700669a4c9a1e9ffc407fa89e6d6c7e21

diff --git a/scripts/crontab.syj b/scripts/crontab.syj
index 78d48be..4dfe865 100644
--- a/scripts/crontab.syj
+++ b/scripts/crontab.syj
@@ -5,3 +5,7 @@ MAILTO=arno@renevier.net
 12 3 3 * * /data/project/syj/scripts/updategeoip.sh
 # every day, delete old sessions files
 47 4 * * * find /tmp/ -name "sess_*" -user syj  -ctime +45 -exec rm -f '{}' \;
+# every day, vacuum tables
+48 4 * * * psql syj syj -c "VACUUM ANALYZE users"
+48 4 * * * psql syj syj -c "VACUUM ANALYZE paths"
+48 4 * * * psql syj syj -c "VACUUM ANALYZE pending_actions"