How Postgres Writes Data: WAL, Shared Buffers, and the Illusion of Speed

PostgreSQL uses shared buffers in RAM for fast writes and a write-ahead log (WAL) for durability. When a query updates data, Postgres modifies the page in memory and appends the transaction to the WAL before confirming success. If the server crashes, Postgres replays the WAL to recover lost dirty pages.