Horton
Menu

Re: Running vacuum on cron

Fran Fabrizio <ffabrizio@mmrd.com>

View thread
From: Fran Fabrizio <ffabrizio@mmrd.com>
To: Pedro Alves <pmalves@think.co.pt>
Cc: PostGreSQL <pgsql-general@postgresql.org>
Date: 2001-10-29T17:48:08Z
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