Evgeny Gridasov wrote:
autovacuum starts even if autovacuum=off is set in config file, I've checked
it through 'show autovacuum' and see it off. But still there is an
autovacuum process vacuuming the tables.
Even when you disable autovacuum with autovacuum=off, it's still
launched to prevent xid wraparound. See the documentation on xid
wrap-around:
http://www.postgresql.org/docs/8.2/interactive/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
and on the autovacuum_freeze_max_age configuration variable for more
information.
is this 8.2.4 CVS-only issue?
No. It's a new feature in the 8.2.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
