The Internals of Postgres – Concurrency Control
This looks to be an excellent, thorough resource on MVCC in Postgres. Here are some others:Chapter 13 of the Postgres official docs -> https://www.postgresql.org/docs/current/static/mvcc-intro.ht...Concurrency Deep Dive talk @ PostgresOpen 2017 -> https://www.youtube.com/watch?v=ZxhBkBNxvR0There is a wealth of good, informative, high signal/noise ratio talks at the PostgresOpen 2017, encourage you to check it outAnd another famously good resource that's not quite related:PostgreSQL internals through pictures -> https://momjian.us/main/writings/pgsql/internalpics.pdf