Breaking away from FREEZE and Wraparound

[zhjwpku]

Workshop Title

Masahiko Sawada - PGCon 2022 Breaking away from FREEZE and Wraparound

Time: April 2026

Resources

• Video: https://www.youtube.com/watch?v=4tfyT9Putzo

[zhjwpku]

Autovacuum is designed to prevent transaction ID wraparound. However, long-running read transactions can block tuple freezing, and tables with autovacuum_enabled = off will not be vacuumed automatically. Are there any other conditions or misconfigurations that could also lead to wraparound issues?

[zhjwpku]

https://rhaas.blogspot.com/2020/02/useless-vacuuming.html