From: Alvaro Herrera <alvherre@commandprompt.com>
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: Autovacuum on defined interval
Date: Tue, 20 Jul 2010 16:52:37 -0400
Message-ID: <1279658949-sup-5628@alvh.no-ip.org> (raw)
In-Reply-To: <006601cb2848$1416dc70$6500a8c0@gibon>
References: <001001cb2827$85bdb8b0$6500a8c0@gibon>
<1279652976-sup-9283@alvh.no-ip.org>
<005f01cb2840$50de3930$6500a8c0@gibon>
<1279655699-sup-258@alvh.no-ip.org>
<006601cb2848$1416dc70$6500a8c0@gibon>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, gibon@comexsystem.com.br
Subject: Re: Autovacuum on defined interval
In-Reply-To: <1279658949-sup-5628@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox