PostgreSQL Database Architecture that guarantee reliability using Write Ahead Logging | WAL скачать в хорошем качестве

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 - https://anands.me If you like my video, consider subscribing to my Youtube channel Thanks for watching, 👋 Anand #database #postgresql #wal