From: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
To: PostgreSQL - mailing list <pgsql-admin@postgresql.org>
Subject: Fw: Autovacuum on defined interval
Date: Tue, 20 Jul 2010 17:18:44 -0300
Message-ID: <007201cb2848$c21c6bf0$6500a8c0@gibon> (raw)
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) ?
2 - what moment autovacuum check se necessary run or not? (when ocurred dml
statament ?)
3 - on autovacuum is executed vacuum with FULL option or not?
4 - if autovacuum is running and i do a reload config setting autovacuum off
this process will be down?
thanks again...
Fábio Gibon
> ----- Original Message -----
> From: "Alvaro Herrera" <alvherre@commandprompt.com>
> To: "Fábio Gibon - Comex System" <gibon@comexsystem.com.br>
> Sent: Tuesday, July 20, 2010 4:55 PM
> Subject: Re: [ADMIN] Autovacuum on defined interval
>
>
>> Excerpts from Fábio Gibon - Comex System's message of mar jul 20
>> 15:18:06 -0400 2010:
>>> thanks for your reply... but i can't shutdown database (24/7)
>>
>> I didn't say shutdown. A reload does not kill existing connections.
>>
>
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: gibon@comexsystem.com.br
Subject: Re: Fw: Autovacuum on defined interval
In-Reply-To: <007201cb2848$c21c6bf0$6500a8c0@gibon>
* 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