pg_upgrade and frozen xids

From: Natalie Wenz <nataliewenz(at)ebureau(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_upgrade and frozen xids
Date: 2018-03-06 23:12:39
Message-ID: C44C73BC-6B3A-42E0-9E44-6CE4E5B5D601@ebureau.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 busy on a large legacy table that has experienced no changes since the upgrade. If the whole table had been frozen prior to the upgrade, would you expect it to stay frozen?

Thanks,
Natalie

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Geoghegan 2018-03-06 23:25:07 Re: pg_upgrade and frozen xids
Previous Message Johannes Truschnigg 2018-03-06 19:39:33 Re: Reliable WAL file shipping over unreliable network