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