Skip site navigation (1) Skip section navigation (2)

Re: pgsql: Document that non-data journaling is a recommended mount option.

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Document that non-data journaling is a recommended mount option.
Date: 2008-12-14 14:18:23
Message-ID: 200812141418.mBEEINh29704@momjian.us (view raw or flat)
Thread:
Lists: pgsql-committers
Jaime Casanova wrote:
> On Sat, Dec 6, 2008 at 4:34 PM, Bruce Momjian <momjian(at)postgresql(dot)org> wrote:
> > Log Message:
> > -----------
> > Document that non-data journaling is a recommended mount option.
> >
> 
> i'm always confused about this... you mean turn off data journaling in
> the disks that stores the datafiles, right? not in the disks where the
> WAL in...
> 
> can be more explicit about one or the other?

You can turn off data journally for WAL and non-WAL disks because we
call fsync() when we need data flushed to disk.  The problem is that by
default ext3 flushes data to disk for table files during journaling
operation.

What additional text needs to be added?

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-committers by date

Next:From: Magnus HaganderDate: 2008-12-14 19:39:37
Subject: pgsql: Replace both send and receive BIO routines in the SSL code with
Previous:From: Jaime CasanovaDate: 2008-12-14 06:02:11
Subject: Re: pgsql: Document that non-data journaling is a recommended mount option.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group