Fw: Autovacuum on defined interval

From: Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br>
To: "PostgreSQL - mailing list" <pgsql-admin(at)postgresql(dot)org>
Subject: Fw: Autovacuum on defined interval
Date: 2010-07-20 20:18:44
Message-ID: 007201cb2848$c21c6bf0$6500a8c0@gibon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)commandprompt(dot)com>
> To: "Fábio Gibon - Comex System" <gibon(at)comexsystem(dot)com(dot)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.
>>
>

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2010-07-20 20:52:37 Re: Autovacuum on defined interval
Previous Message Alvaro Herrera 2010-07-20 19:10:34 Re: Autovacuum on defined interval