News for hackers. Stuff that matters.

A comment on SQLite (with WAL) doesn't do `fsync` on each commit under default settings. Parent comment

Re:SQLite (with WAL) doesn't do `fsync` on each commit under... by dgshsg on Monday August 25, 2025 @03:35AM (#45011281)
You still need to wait for it to complete to report the commit success to the user, the cost of syscall itself is rather minor here.
[ Parent | on HN ]
Re:SQLite (with WAL) doesn't do `fsync` on each commit under... by senderista on Monday August 25, 2025 @02:47PM (#45017454)
Avoiding the syscall cost is about maximizing throughput, not minimizing latency. The media's time-to-durability is what it is.
[ Parent | on HN ]