Running vacuum on cron

From: Pedro Alves <pmalves(at)think(dot)co(dot)pt>
To: PostGreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Running vacuum on cron
Date: 2001-10-29 16:42:22
Message-ID: 20011029164222.A13735@cosmos.inesc.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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?

Thanks

--
Pedro Miguel G. Alves

THINK - Tecnologias de Informação
Av. Defensores de Chaves nº 15 4ºD, 1000-109 Lisboa Portugal
Tel: +351 21 3590285 Fax: +351 21 3582729
HomePage: www.think.co.pt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-29 17:15:29 Re: More On 7.2 Distributions - Estimates For Number Distinct < 0
Previous Message Paulo Jan 2001-10-29 16:32:29 Re: Optimizing a complex query (long)