> > As part of checkpoint, we discard some WAL files. To do that, we must > > first be sure that all the dirty buffers we have written to the kernel > > are actually on the disk. That is why the sync() is required. > > What we really need is something better than sync(), viz flush all dirty > buffers to disk *and* wait till they're written. But sync() and sleep > for awhile is the closest portable approximation.
Are you saying that fsync() might not wait untill the IO completes? -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html