Write-ahead logging

In computer science, write-ahead logging (WAL) is a family of techniques for providing atomicity and durability (two of the ACID properties) in database systems.[1]

A write ahead log is an append-only auxiliary disk-resident structure used for crash and transaction recovery. The changes are first recorded in the log, which must be written to stable storage, before the changes are written to the database.[2]

  1. ^ Hellerstein, Joseph M.; Stonebraker, Michael; Hamilton, James (2007). Architecture of a database system. Boston: Now. ISBN 978-1-60198-079-3. OCLC 191079239.
  2. ^ "30.3. Write-Ahead Logging (WAL)". PostgreSQL Documentation. 2023-05-11. Archived from the original on 2025-04-08. Retrieved 2023-06-05.

© MMXXIII Rich X Search. We shall prevail. All rights reserved. Rich X Search