TLDR


A frozen row is a row whose inserting transaction is so safely in the past that Postgres can treat it as visible to all future transactions. This helps vacuum avoid transaction ID wraparound issues.




What does a frozen row mean in Postgres?


If you’ve ever looked at the docs for vacuuming in Postgres, you may have seen the term...