Re: fsync = true beneficial on ext3?

"Ed L." <pgsql@bluepolka.net> writes:
> If we write something without sync'ing, presumably it's immediately
> journaled?

I was under the impression that ext3 journals only filesystem metadata,
not the contents of files.

> I've been running a few pgsql clusters on ext3 with fsync =
> false, suffered numerous OS crashes, and have yet to lose any data or see
> any corruption from any of those crashes.  Have I just been lucky?

Doesn't sound very safe to me.

            regards, tom lane