pg_upgrade and frozen xids - Mailing list pgsql-admin

From Natalie Wenz
Subject pg_upgrade and frozen xids
Date
Msg-id C44C73BC-6B3A-42E0-9E44-6CE4E5B5D601@ebureau.com
Whole thread Raw
Responses Re: pg_upgrade and frozen xids  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-admin
What happens to the xid of rows/tables when you upgrade postgres via pg_upgrade?

I upgraded a very large database from 9.6 to 10.1 via pg_upgrade recently, and ever since, the auto vacuum has been
busyon a large legacy table that has experienced no changes since the upgrade. If the whole table had been frozen prior
tothe upgrade, would you expect it to stay frozen?  

Thanks,
Natalie

pgsql-admin by date:

Previous
From: Johannes Truschnigg
Date:
Subject: Re: Reliable WAL file shipping over unreliable network
Next
From: Peter Geoghegan
Date:
Subject: Re: pg_upgrade and frozen xids