Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


In response to

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group