Ravi Krishna <s.ravikrishna@aim.com> writes:
> Am I right in concluding that PG WAL writes without underlying h/w caching is not crash proof.
We expect that the hardware+OS honors fsync() correctly, ie puts the data
on durable storage before fsync returns. That does not mean anything one
way or the other about caching, it just means that the filesystem stack
has to be correctly implemented.
regards, tom lane
