Re: sync vs. fsync question - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: sync vs. fsync question
Date
Msg-id 200406010148.i511mxJ17994@candle.pha.pa.us
Whole thread Raw
In response to sync vs. fsync question  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne wrote:
> Hi,
> 
> I had this question posed to me on IRC and I didn't know the answer.
> 
> If all that is needed to ensure integrity is that the WAL is fsynced, 
> what is wrong with just going:
> 
> wal_sync_method = fsync
> fsync = false

wal_sync_method is only used if fsync is true.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: sync vs. fsync question
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Fast index build vs. PITR