Hi All,
I'm supposed to put together a plan for the routine maintenance of the new database we are building using v7.4, and I have a question or two.
I'm interested in the auto vacuum daemon, but havn't located any good information about it so far, I'd like to know if people generally recommend using it or not.
If we use it, can we stop using nightly vacuums? I'd like to do this if possible, since the current version (it's a 7.1 db) of the system runs a number of batch processes at night (large deletes and large inserts), and finishes with a vacuum analyse. The vacuum takes quite a long time and the nightly window is gradually getting tighter and tighter.
On the other hand, the system is quite busy during the day, and once the batch processes have finished the system is idle until about 9am.
The system is used 365 days a year, which doesn't leave much opportunity for VACUUM FULL or unload reloads.
If I start a VACUUM FULL, is it ok to interrupt it part way through? I mean, is a partially completed vacuum full worth anything, and is there any danger in routinely killing it?
Thanks for your help,
regards
Iain