Postgres Pro
Downloads
Home   >   mailing lists

Thread: fsync on 7.1

fsync on 7.1

From
Joseph Shraibman
Date:
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?

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com

Re: fsync on 7.1

From
Tom Lane
Date:
Joseph Shraibman <jks@selectacast.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

Re: fsync on 7.1

From
Joseph Shraibman
Date:
Tom Lane wrote:
>
> Joseph Shraibman <jks@selectacast.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@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com