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
/-------------------------- signal@shreve.net -----------------------------\
| Brian Feeny | USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting, online stores, |
| ShreveNet Inc. | USR Pilot | Dial-Up 14.4-56k, ISDN & LANs |
| 89 CRX DX w/MPFI, lots of |-=*:Quake:*=-| http://www.shreve.net/ |
| mods/Homepage coming soon |LordSignal/SN| Quake server: 208.206.76.47 |
\-------------------------- 318-222-2638 x109 -----------------------------/