Re: Problem with pg_upgrade?
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Alvaro Herrera <alvherre@commandprompt.com>, Jeff Davis <pgsql@j-davis.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-03-30T21:44:13Z
Lists: pgsql-hackers
Bruce Momjian wrote: > > I wonder if the fact that these people never reported the bug means > > there were doing something odd with their servers. > > I just updated the C comment about what we are doing: > > * Using autovacuum=off disables cleanup vacuum and analyze, but > * freeze vacuums can still happen, so we set > * autovacuum_freeze_max_age very high. We assume all datfrozenxid and > * relfrozen values are less than a gap of 2000000000 from the current > * xid counter, so autovacuum will not touch them. FYI, 2000000000 is the maximum value for autovacuum_freeze_max_age, so a user can't set it higher. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +