easy5 pts · first answer countspostgresqltransactions

Why a write-ahead log exists

What is the main purpose of the write-ahead log (WAL in PostgreSQL, redo log in InnoDB)?

A.To store query results for faster readsB.To keep a list of users who logged inC.To compress old table dataD.To record changes durably before data pages are written, so the database can recover after a crash

← RPO and RTO Read-only access for analysts →