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

From Peter Eisentraut
Subject Re: Disable page writes when fsync off, add GUC
Date
Msg-id 200507041800.49660.peter_e@gmx.net
Whole thread Raw
In response to 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:
> This patch disables page writes to WAL when fsync is off, because
> with no fsync guarantee, the page write recovery isn't useful.
>
> This also adds a full_page_writes GUC to turn off page writes to WAL.
> Some people might not want full_page_writes, but still might want
> fsync.

Do you have some numbers to suggest that there is a performance benefit
to be had?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-patches by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: User's exception plpgsql
Next
From: Bruce Momjian
Date:
Subject: Re: Disable page writes when fsync off, add GUC