| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #3261: autovacuum starts regarding config setting |
| Date: | 2007-05-04 09:25:49 |
| Message-ID: | 463AFC1D.2030709@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2007-05-04 10:57:25 | Re: BUG #3261: autovacuum starts regarding config setting |
| Previous Message | Evgeny Gridasov | 2007-05-04 02:12:20 | BUG #3261: autovacuum starts regarding config setting |