Jan Wieck <JanWieck@Yahoo.com> writes:
> Removing sync() entirely requires very accurate fsync()'ing in the
> background writer, the checkpointer and the backends. Basically none of
> them can mark a block "clean" if he fails to fsync() the relation later!
> This will be a mess to code.
Not really. The O_SYNC solution for example would be trivial to code.
regards, tom lane