logoalt Hacker News

Sesse__yesterday at 1:01 PM2 repliesview on HN

Because it is in addition to your writes, not instead of them. That's what “ahead” points to.


Replies

_bohmyesterday at 1:16 PM

The actual writes don’t need to be persisted on transaction commit, only the WAL. In most DBs the actual writes won’t be persisted until the written page is evicted from the page cache. In this sense, writing WAL generally does provide better perf than synchronously doing a random page write

Tostinoyesterday at 2:39 PM

Look up how "checkpointing" works in Postgres.

show 1 reply