Fw: Autovacuum on defined interval

Fw: Autovacuum on defined interval

am 20.07.2010 22:18:44 von gibon

Perfect!!!

I'm starting with PostgreSQL (my knowledge is Oracle). Can you explain mo=
re=20
about autovacuum? for example...

1 - on windows SO, autovacuum start works (postgres.exe as=20
autovacuum_max_workers) ?

2 - what moment autovacuum check se necessary run or not? (when ocurred d=
ml=20
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=20
this process will be down?

thanks again...

F=E1bio Gibon
> ----- Original Message -----=20
> From: "Alvaro Herrera"
> To: "F=E1bio Gibon - Comex System"
> 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=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.
>>
>=20


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin