Re: sync vs. fsync question

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: sync vs. fsync question
Date: 2004-06-01 01:48:59
Message-ID: 200406010148.i511mxJ17994@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-06-01 01:53:38 Re: Fast index build vs. PITR
Previous Message Christopher Kings-Lynne 2004-06-01 01:45:34 sync vs. fsync question