Re: Problem with pg_upgrade? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Problem with pg_upgrade?
Date
Msg-id 201103302144.p2ULiDV29689@momjian.us
Whole thread Raw
In response to Re: Problem with pg_upgrade?  (Bruce Momjian <bruce@momjian.us>)
List 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. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade and PGCLIENTENCODING
Next
From: Merlin Moncure
Date:
Subject: Re: Process local hint bit cache