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--
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
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
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