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

Re: fsync on 7.1

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: fsync on 7.1
Date: 2001-05-01 02:45:25
Message-ID: 3AEE2345.36EB633D@selectacast.net (view raw or flat)
Thread:
Lists: pgsql-general
Tom Lane wrote:
> 
> Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> > If I turn off fsync on 7.1 does that mean that the wal file is sync'd
> > (according to WAL_SYNC_METHOD in the log file) and other files are not?
> > Or does fsync apply to all file equally?
> 
> The latter.  Note where the docs say:
> 
> The WAL_SYNC_METHOD parameter determines how Postgres will ask the
> kernel to force WAL updates out to disk. All the options should be the
> same as far as reliability goes, but it's quite platform-specific which
> one will be the fastest. Note that this parameter is irrelevant if FSYNC
> has been turned off.
> 
>                         regards, tom lane

Err... where is that?  I'm looking at
/usr/local/pgsql/doc/html/runtime-config.html#RUNTIME-CONFIG-WAL

-- 
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio.  http://www.targabot.com

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2001-05-01 03:05:36
Subject: Re: Minor documentation bug
Previous:From: Tom LaneDate: 2001-05-01 02:39:52
Subject: Re: fsync on 7.1

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