I was wondering, when we start to reuse a WAL file, do we know that all
dirty buffers modified in that WAL file have been flushed to disk? Do
we fsync() dirty buffers at time of checkpoint, and do we also make sure
that buffers we wrote to disk and later reused before the checkpoint
also made it to disk?
My point is that writing it to the kernel doesn't guarantee it made it
to disk.
I see the WAL records being fsync'ed in xlog.c but I don't see the
buffer pages being fsynced.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026