Re: Disable page writes when fsync off, add GUC

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "PostgreSQL-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Disable page writes when fsync off, add GUC
Date: 2005-07-06 08:23:32
Message-ID: 03eb01c58204$00e5d6f0$0f01a8c0@zaphod
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-07-06 09:56:42 Re: timezone changes break windows and cygwin
Previous Message Tom Lane 2005-07-06 04:55:45 Re: timezone changes break windows and cygwin

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2005-07-06 08:24:33 Re: INSERT ... RETURNING
Previous Message Neil Conway 2005-07-06 07:55:39 Re: patch: garbage error strings in libpq