Freezing Through Pictures

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, it is important to understand the concepts of Transaction Wrap Around to make informed design, monitoring, and administration decisions. Through a series of diagrams, pictures, and animations, this talk will give an overview of the Postgres MVCC architecture. Using the same approach, this talk will then go into technical details around the meaning and dangers associated with Transaction Wrap Around and the role that Tuple Freezing plays in avoiding serious outage events.