Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Can someone tell me why we need sync() here?
> ?? I thought WAL files are synced by pg_fsync() (if needed).
They are. But to write a checkpoint record --- which implies that the
WAL records before it need no longer be replayed --- we have to ensure
that all the changes-so-far in the regular database files are written
down to disk. That is what we need sync() for.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
