P.S.:A TODO for me: CRON Script for weekly VACUUM ;)
on heavy use databases, mine generally does a light vacuum every 4 hours, and a once a day full on everything. also, a weekly full reindex on a really really heavy use systems like this one message board server I ad-mangle
something like...
7 */4 * * * vacuumdb busy_database >/dev/null 2>/dev/null 37 0 * * * vacuumdb -a -z >/dev/null 2>/dev/null 37 2 * * Sun reindexdb -a > /dev/null 2>/dev/null
many might say this is total overkill, I dunno. keeps this server happy. btw, reindexdb is a script from contrib.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
