"Ed L." <pgsql(at)bluepolka(dot)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