Re: Disable page writes when fsync off, add GUC - Mailing list pgsql-patches

From Michael Paesold
Subject Re: Disable page writes when fsync off, add GUC
Date
Msg-id 03eb01c58204$00e5d6f0$0f01a8c0@zaphod
Whole thread Raw
In response to Re: Disable page writes when fsync off, add GUC  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Disable page writes when fsync off, add GUC  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian wrote:

> Bruce Momjian wrote:
>> This also adds a full_page_writes GUC to turn off page writes to WAL.
>> Some people might not want full_page_writes.
>
> Fsync linkage removed, patch attached and applied.

...
+     When this option is on, the <productname>PostgreSQL</> server
+     writes full pages to WAL when they first modified after a checkpoint
+     so full recovery is possible.

I believe this should be "when they _are_ first modified after".

Perhaps you should also mention power failure, not only an operating system
crash as disaster scenario, even if the latter includes the former.

Best Regards,
Michael Paesold


pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: patch: garbage error strings in libpq
Next
From: Neil Conway
Date:
Subject: Re: INSERT ... RETURNING