Re: fsync = true beneficial on ext3?

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: fsync = true beneficial on ext3?
Date: 2004-02-09 02:13:08
Message-ID: 4026ECB4.8090409@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

FYI - Ext3 has 3 modes :

data=ordered(default) : metadata is journaled (at write time data is
written before metadata - i.e ordered)
data=journal: data and metadata are journaled
data=writeback: metadata journaled (no ordering at write time)

The default will not help to protect database integrity if fsync is
false (as only metadata is journaled)

Will data=journal mode help? I am uncertain. A casual reading if these
definitions suggests that it *might* - anyone know for sure?

regards

Mark

Richard Welty wrote:

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-02-09 02:40:11 Re: PostgreSQL 7.4.1 and pgdb.py
Previous Message Manuel Tejada 2004-02-09 01:37:08 Re: PostgreSQL 7.4.1 and pgdb.py