Lincoln Yeoh <lylyeoh@mecomb.com> writes:
> Actually, say if I use postgresql on a journalling file system, would this
> problem go away?
Not unless your kernel guarantees to write dirty buffers to disk in the
order they were dirtied, which would be a fairly surprising thing for it
to guarantee IMHO; that's not how Unix buffer caches normally behave.
regards, tom lane