Re: Running vacuum on cron

From: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
To: Pedro Alves <pmalves(at)think(dot)co(dot)pt>
Cc: PostGreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Running vacuum on cron
Date: 2001-10-29 17:48:08
Message-ID: 3BDD9658.F881C3C8@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pedro Alves wrote:

> Hi. Is there any way to put a vacuum and a vacuum analyze (the
> second does everything the first does? Or do I need to use both?) in a cron
> so that it is executed nightly?

Sure....this is from my cron...

30 0 * * * /usr/local/pgsql/bin/vacuumdb -q -a

-Fran

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-10-29 17:48:22 Re: Select limit... erm so..
Previous Message Robert B. Easter 2001-10-29 17:26:33 Re: trigger function in plpgsql (newbie)