Re: Autovacuum on defined interval - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Autovacuum on defined interval
Date
Msg-id 1279652976-sup-9283@alvh.no-ip.org
Whole thread Raw
In response to Autovacuum on defined interval  (Fábio Gibon - Comex System<gibon@comexsystem.com.br>)
List pgsql-admin
Excerpts from Fábio Gibon - Comex System's message of mar jul 20 12:20:36 -0400 2010:
> Hi everybody,
>         are there how define autovacuum to ON and define the period time (for example, 00h - 06h) that it's can run?

You could have a script that toggles the value in postgresql.conf and do
a Postgres reload, and run that script in cron.

pgsql-admin by date:

Previous
From: Fábio Gibon - Comex System
Date:
Subject: Custom vacuum
Next
From: Fábio Gibon - Comex System
Date:
Subject: Fw: Autovacuum on defined interval