Autovacuum on defined interval

This is a multi-part message in MIME format.

------=_NextPart_000_000D_01CB280E.573C3D90
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi everybody,
are there how define autovacuum to ON and define the period time =
(for example, 00h - 06h) that it's can run?

tks
=20
F=E1bio Henrique Gibon
Comex System Consultoria
------=_NextPart_000_000D_01CB280E.573C3D90
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable



charset=3Dwindows-1252"> href=3D"file://C:\Arquivos de programas\Arquivos comuns\Microsoft =
Shared\Papel de carta\">

Re: Autovacuum on defined interval

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?
> =20

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
> =20
> Fábio Henrique Gibon
> Comex System Consultoria

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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Autovacuum on defined interval

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 tim=
e (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.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Autovacuum on defined interval

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

I think questions (1) and (2) are best answered in the docs:
http://www.postgresql.org/docs/current/static/routine-vacuum ing.html#AUTO=
VACUUM
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 autovacuu=
m off=20
> this process will be down?

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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin