As promised in a previous article, let’s discuss what MVCC is and why it is fundamenta to the workings of PostgreSQL. Even if you are a dev and not a DBA, I believe it is very helpful to have at least a rough understanding of how it works. Let us start with an example. We have a very simple schema such as: create table book ( book_id bigint, title varchar(256) ); insert into book (book_id, title) values (1, 'The lord of the rings'), (2, 'Crime and punishment'), (3, 'The moon is a harsh mist...
