C
Oct 12, 2026Calculating WAL Generation for DML Operations in PostgreSQL
PostgreSQL provides the EXPLAIN command with the ANALYZE and WAL options to measure the WAL generated...
Oct 12, 20263 min read1 reactions1 comments
Back to articles 
Oct 10, 2026
Apr 23, 2026
Tag archive
#wal
wal_checkpoint Counted 15,000 Frames, Moved Zero
On the server behind the site you are reading right now, the database that holds runtime data has a...
Oct 10, 202615 min read7 reactions0 comments
E
Sep 14, 2026Every Postgres Write Triggers Five Background Processes. Here's What Each One Actually Does.
An UPDATE statement returns in two milliseconds. From where you're sitting, that's the whole story:...
Sep 14, 20266 min read0 reactions0 comments
W
Aug 28, 2026WAL as the Source of Truth: What Lakebase Storage on S3 Means for You
Every Postgres you have ever run keeps two copies of the truth: the data files, and the write-ahead...
Aug 28, 20269 min read9 reactions0 comments
W
Jul 7, 2026Write-Ahead Logging — WAL Fundamentals
WAL: vì sao Postgres bắt buộc ghi log trước data file, và lý do pg_wal/ đầy đĩa làm cluster...
Jul 7, 202613 min read0 reactions0 comments
Write-Ahead Log: Durability in Database Systems
Write-Ahead Log: The Unsung Hero of Database Durability Imagine you're in the middle of...
Apr 23, 20266 min read0 reactions0 comments
P
Aug 29, 2025Postgres Replication Slots
The WAL(Redo log) is essential to normal database operations. In some sense "The LOG is the DATABASE"...
Aug 29, 20258 min read0 reactions1 comments