Re: AutoVacuum on demand? - Mailing list pgsql-general

From Glen Parker
Subject Re: AutoVacuum on demand?
Date
Msg-id 4553D4AC.8090001@nwlink.com
Whole thread Raw
In response to Re: AutoVacuum on demand?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: AutoVacuum on demand?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Joshua D. Drake wrote:
> On Thu, 2006-11-09 at 17:00 -0800, Glen Parker wrote:
>> I would like a way to run the autovacuum daemon on demand periodically.
>>    Every night at 2 AM, for example.
>>
>> Anybody know if this is possible?  If not, it's a feature request :-)
>
> use vacuumdb and cron.

Cron yes, vacuumdb no.  I would like to AUTO vacuum periodically.

-Glen

pgsql-general by date:

Previous
From: Ottavio Campana
Date:
Subject: blocking function in PL/Python
Next
From: Tom Lane
Date:
Subject: Re: planer picks a bad plan (seq-scan instead of index) when adding an additional join