Get the latest tech news

Deep Dive into Postgres Write-Ahead Logs


This is the second part of our deep-dive into Postgres logical replication. In this part, we will focus on Postgres Write-Ahead Logs (WAL).

Log sequence numbers are 64-bit integers assigned to individual transactions within a WAL, indicating the INSERT position. This parameter specifies the maximum size of the WAL files that the replication slots retain at the time of checkpoint. The size helps to limit the amount of data written to disk while also considering potential lag caused by replication.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of deep dive

deep dive

Photo of ahead

ahead

Photo of logs

logs

Related news:

News photo

Show HN: Parse your Postgres queries into a fully-typed AST in TypeScript

News photo

Rainfrog – a database management TUI for Postgres

News photo

Agentic AI: A deep dive into the future of automation