PostgreSQL Database Architecture that guarantee reliability using Write Ahead Logging | WAL 

Durability or Reliability is one of the important properties supported by database systems like Postgres and MySQL. It means that once a transaction is commited, you'll never lose the data even in the case of a crash or failure. Databases use write ahead logging to guarantee the reliability of your data. But do you know how WAL works?
In this video, I'll explain the internal architecture of a database (Postgres specifically), data file structure, page layout and everything that is done to ensure the durability of your data. We'll discuss WAL or Write ahead logs, redo/replay mechanism etc.
This video is easy to understand for beginners.
00:00 Introduction
1:05 Transactions
2:52 Internal storage architecture of Postgres
5:36 Execution of an UPDATE query
8:25 What is Write Ahead Log or WAL
13:40 Why WAL, and why not the data file
16:40 Redo/Replay mechanism
19:20 Reliability of WAL storage
Follow me for more content on software engineering and system design.
Twitter - / anandrmedia
Website - anands.me
If you like my video, consider subscribing to my RU-vid channel
Thanks for watching,
👋 Anand
#database #postgresql #wal