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/i...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