Introduction In the previous post, we covered transactions, ACID properties, and isolation levels. We discussed how databases handle concurrent transactions and the different isolation levels available. But we didn't dive into how Postgres actually implements these features. This post will cover Multi-Version Concurrency Control (MVCC), which is the

Introduction In the previous post, we discussed how to study databases and the resources to use. In this post, we will dive into the core of databases: Transactions. The reason I'm starting with transactions because they are (in my opinion) the most important concept in databases. When you

My Desktop Setup Introduction Since I was a computer science student, the study of databases has always been the most interesting topic for me. When you study how databases work, you will touch every aspect of computer science, from algorithms, data structures, operating systems, networking, and distributed systems to concurrency.