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

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252"><BASE
href=3D"file://C:\Arquivos de programas\Arquivos comuns\Microsoft =
Shared\Papel de carta\">
<STYLE></STYLE>

<META content=3D"MSHTML 6.00.2900.3132" name=3DGENERATOR></HEAD>
<BODY background=3D"">
<DIV>Hi everybody,</DIV>
<DIV>        are there how define =
autovacuum
to ON and define the period time (for example, 00h - 06h) that it's =
can
run?</DIV>
<DIV> </DIV>
<DIV>tks</DIV>
<DIV> <BR>F=E1bio Henrique Gibon<BR>Comex System
Consultoria</DIV></BODY></HTML>

------=_NextPart_000_000D_01CB280E.573C3D90--
gibon [ Di, 20 Juli 2010 18:20 ] [ ID #2044807 ]

Re: Autovacuum on defined interval

On Tue, 2010-07-20 at 13:20 -0300, F=C3=A1bio 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=C3=A1bio 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


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Joshua Drake [ Di, 20 Juli 2010 19:03 ] [ ID #2044808 ]

Re: Autovacuum on defined interval

Excerpts from F=C3=A1bio 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.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
alvherre [ Di, 20 Juli 2010 21:10 ] [ ID #2044810 ]

Re: Autovacuum on defined interval

Excerpts from F=C3=A1bio 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-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
> this process will be down?

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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
alvherre [ Di, 20 Juli 2010 22:52 ] [ ID #2044812 ]
Datenbanken » gmane.comp.db.postgresql.admin » Autovacuum on defined interval

Vorheriges Thema: Weird sorting order
Nächstes Thema: Fw: Autovacuum on defined interval