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:49:50
Message-ID: 3BDD96BE.3AB9D20A@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?

Sorry to double, but the -z flag on vacuumdb will also do the analyze for you,
so you can do it all in one command.

-Fran

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-10-29 17:55:20 Re: initdb segfault - solaris 8
Previous Message Bruce Momjian 2001-10-29 17:48:22 Re: Select limit... erm so..