Re: fsync = true beneficial on ext3?

From: Richard Welty <rwelty(at)averillpark(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: fsync = true beneficial on ext3?
Date: 2004-02-08 19:29:41
Message-ID: Mahogany-0.66.0-16912-20040208-142941.00@averillpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 08 Feb 2004 14:02:26 -0500 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "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.

by default, it journals everything, but you can set it to journal metadata
only, i think with the mount option data=writeback. do a "man mount"
and look for ext3 options for details on the data= option.

richard
--
Richard Welty rwelty(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message elein 2004-02-08 19:36:07 Re: Fwd: Favorite DB poll on ORA
Previous Message Josh Berkus 2004-02-08 19:23:48 Re: Fwd: Favorite DB poll on ORA