Heikki Linnakangas wrote:
> On 31.03.2011 17:55, Bruce Momjian wrote:
> > I will work on code to allow autovacuum_max_workers to be set to zero in
> > HEAD and 9.0, and have pg_upgrade us that.
> We've intentionally not allowed the user to disable anti-wraparound
> autovacuum before. Do we really want to allow it now for the sake of
> > I think the maintenance
> > overhead of an invisible variable is too much.
> A simple GUC or command-line switch isn't much code.
Well, is this going to show in SHOW ALL or pg_settings? Do we have the
ability to easily disable display of this?
> Is the problem just that the clog files get removed too early, or is
> there something else? If it's just the clog files, we could simply copy
> them (again) after updating datfrozenxids.
The problem is that pg_upgrade through pg_dumpall is setting
pg_database/pg_class frozen xid values and I can't have autovacuum
modifying the system while this is happening.
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
+ It's impossible for everything to be true. +
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2011-03-31 16:08:34|
|Subject: Re: Problem with pg_upgrade?|
|Previous:||From: Brendan Jurd||Date: 2011-03-31 16:07:07|
|Subject: Re: [HACKERS] Date conversion using day of week|