pg_upgrade and frozen xids

Поиск
Список
Период
Сортировка
От Natalie Wenz
Тема pg_upgrade and frozen xids
Дата
Msg-id C44C73BC-6B3A-42E0-9E44-6CE4E5B5D601@ebureau.com
обсуждение исходный текст
Ответы Re: pg_upgrade and frozen xids  (Peter Geoghegan <pg@bowt.ie>)
Список 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 по дате отправления:

Предыдущее
От: Johannes Truschnigg
Дата:
Сообщение: Re: Reliable WAL file shipping over unreliable network
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: pg_upgrade and frozen xids