Re: [GENERAL] vacuuming

> Is it common practice to setup a cron job to vacuum your databases
> nightly?  Do you just do something like:
>
> psql my_db < vacuum
>
> in cron?  I was reading about administration and it talked about how
> vacuuming is such a good idea and all.
>
> If i am going to cron vacuum, is there anything else I should be doing, or
> is just "psql my_db < vacuum" all that needs done on a nightly basis.
>

Brian,

you might try adding a something to the shell script that you are kicking off
with cron a dump of your databases.  After you dump them, then you could also
push them to another machine on your network, or if a tape is in the tape drive,
write them to tape.

That's just good old UNIX admin advice; I hope its helpful...james