SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then

0085 — synchronous_commit=local is not measured

Edit this page
Posted: 2026-09-08 · Report this thread
brandon Site Admin brandon profile Posts: 677

Context. synchronous_commit has five levels; besides on and off there is local, which relaxes only the wait for a synchronous standby, not the local WAL flush.

Decision. Do not measure local. On a single node with no synchronous standby, on, local, remote_write, and remote_apply all behave identically as “wait for local flush”; only off skips the fsync, so local would measure as on.

Consequences. A real local measurement would require standing up a streaming replica, which is out of scope for a measure-only phase. If replication is ever added, local becomes a distinct point worth measuring.