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@xxxxxxxxxxxxxxxxx>
To: "Fábio Gibon - Comex System" <gibon@xxxxxxxxxxxxxxxxxx>
Sent: Tuesday, July 20, 2010 4:55 PM
Subject: Re: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
