Re: Multicolumn index corruption on 8.4 beta 2

Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Yeah, AFAICT the writes are handed off to the operating system (just
> not synced), so if it flushes its caches sanely at all there
> shouldn't be a problem.
I would certainly *hope* that's the case.  We sometimes use fsync=off
for conversions, where we plan to just start over if the conversion
crashes, and set it to on when the conversion is done.  It would be
disturbing to discover that fsync=off also means "don't bother to
write dirty buffers to the OS before shutdown."
-Kevin