Обсуждение: Autovacuum on defined interval

Поиск
Список
Период
Сортировка

Autovacuum on defined interval

От
Fábio Gibon - Comex System
Дата:
Hi everybody,
        are there how define autovacuum to ON and define the period time (for example, 00h - 06h) that it's can run?
 
tks
 
Fábio Henrique Gibon
Comex System Consultoria

Re: Autovacuum on defined interval

От
"Joshua D. Drake"
Дата:
On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote:
> Hi everybody,
>         are there how define autovacuum to ON and define the period
> time (for example, 00h - 06h) that it's can run?
>

No. You would need to write your own job manager (or use one of the many
that already exist) and vacuum via it.

JD

> tks
>
> Fábio Henrique Gibon
> Comex System Consultoria

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering

Re: Autovacuum on defined interval

От
Alvaro Herrera
Дата:
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.

Re: Autovacuum on defined interval

От
Alvaro Herrera
Дата:
Excerpts from Fábio Gibon - Comex System's message of mar jul 20 16:13:39 -0400 2010:
> Perfect!!!
>
> I'm starting with PostgreSQL (my knowledge is Oracle). Can you explain more
> about autovacuum? for example...
> 1 - on windows SO, autovacuum start works (postgres.exe as
> autovacuum_max_workers) ?

I think questions (1) and (2) are best answered in the docs:
http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM
Please have a read and let us know if you have further questions.

> 3 - on autovacuum is executed vacuum with FULL option or not?

No, by design autovacuum never invokes any blocking activity.

> 4 - if autovacuum is running and i do a reload config setting autovacuum off
> this process will be down?

The launcher will be shut down, but any worker currently processing
tables will continue until finished with its tables.

Re: Autovacuum on defined interval

От
"Joshua D. Drake"
Дата:
On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote:
> Hi everybody,
>         are there how define autovacuum to ON and define the period
> time (for example, 00h - 06h) that it's can run?
>

No. You would need to write your own job manager (or use one of the many
that already exist) and vacuum via it.

JD

> tks
>
> Fábio Henrique Gibon
> Comex System Consultoria

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering