Re: Running vacuum on cron - Mailing list pgsql-general

From Fran Fabrizio
Subject Re: Running vacuum on cron
Date
Msg-id 3BDD96BE.3AB9D20A@mmrd.com
Whole thread Raw
In response to Running vacuum on cron  (Pedro Alves <pmalves@think.co.pt>)
List 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


pgsql-general by date:

Previous
From: gateley@jriver.com
Date:
Subject: Re: Running vacuum on cron
Next
From: "Ian Harding"
Date:
Subject: Differential Backups