The Postgres Implementation of Multi-Version Concurrency Control has many technical advantages and strengths. However, if you are deploying a large database, with a heavy write update, insert and delete workload the concepts around Transaction Wrap around are very important to understand so proper design, monitoring and administration decisions can be made.
Through a series of diagrams, pictures and animations, this talk gave an overview of the Postgres MVCC architecture. Using the same approach, this talk then went into technical details around the meaning and dangers associated with Transaction wrap around and the role Tuple Freezing plays in avoiding serious outage events.
The webinar concluded with recommendations on how to properly tune monitor and design for the issue associated with Transaction wrap around and Tuple Freezing.