Re: fsync = true beneficial on ext3? - Mailing list pgsql-general

From Tom Lane
Subject Re: fsync = true beneficial on ext3?
Date
Msg-id 4348.1076266946@sss.pgh.pa.us
Whole thread Raw
In response to fsync = true beneficial on ext3?  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: fsync = true beneficial on ext3?  (Richard Welty <rwelty@averillpark.net>)
Re: fsync = true beneficial on ext3?  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: connectby for BYTEA keys
Next
From: Tom Lane
Date:
Subject: Re: Repost: postmaster growing to consume all memory