postgres=# select * from sessions where video_id = 'bfPdLjdQvwU';
Vibe Hacking with Dmitry Fomin
Wait-event observability and precise tracing ideas.
session summary
Dmitry Fomin presented his first core patch after tracing synchronous-replication latency spikes to blocking fdatasync calls in the standby WAL receiver, even under synchronous_commit=remote_write. His prototype batches flushes by byte threshold or timeout. Review uncovered unsafe defaults for stronger synchronous modes and suggested a separate flusher process as a cleaner long-term design. They rebased the old patch onto master, removed redundant unflushed-byte state, compiled it, and prepared it for pgsql-hackers discussion.
timecodes
- Production SyncRep latency problem
- fdatasync stalls in remote_write mode
- Batching WAL flushes by bytes or timeout
- What synchronous replication actually guarantees
- Reviewing the new WAL-receiver settings
- Defaults break stronger synchronous-commit modes
- Alternative design with a separate WAL flusher
- Rebasing, reviewing, and preparing the patch