Re: fsync - Mailing list pgsql-general

From Stephen Robert Norris
Subject Re: fsync
Date
Msg-id 1079477434.5713.0.camel@ws12.commsecure.com.au
Whole thread Raw
In response to fsync  (Mark Lubratt <mark.lubratt@indeq.com>)
List pgsql-general
On Wed, 2004-03-17 at 06:58, Mark Lubratt wrote:
> OK.  I'm getting a little confused.
>
> I have two mirrored SCSI drives on our production server.  For the
> safest operation, do I want fsync=true?  Or fsync=false?  Or just the
> default?
>
> Thanks!
> Mark

For any sort of recoverability after a crash, you need fsync on. That
should be the default for any sane filesystem build...

    Stephen

Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: fsync
Next
From: "Siew Hui, Wong"
Date:
Subject: LWP::Simple in Postgresql 7.3.4