> On Sun, 26 Jul 1998, Herouth Maoz wrote:
>
> > At 23:36 +0300 on 24/7/98, Richard Lynch wrote:
> >
> >
> > > Well, let's try crontab -e and mess around to find out the answers to these
> > > questions. Or at least to see if I can just ignore this whole MAILTO thing
> > > for now. I can always do crontab -r and blow it away.
> >
> > I nearly fell off my chair laughing... You know, on my personal TODO list
> > there's a little item "Write crons for VACUUM", which has been there for
> > months, and I keep postponing it.
>
> I'm another one of those people... so I wrote a quick & dirty c program to
> vacuum ALL my databases. I just mailed it to Marc Fournier
> (scrappy@hub.org) because I didn't know what to do with it, but if anyone
> else wants it just drop me a line directly.
>
Here is a little shell script to do it.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
psql -l -A -q -t|cut -d"|" -f1 | while read DATABASE
do
psql -q -c vacuum $DATABASE
done