Re: [PATCHES] Disable page writes when fsync off, add GUC

2005-07-06 Thread Bruce Momjian
Michael Paesold wrote: > 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,

Re: [PATCHES] Disable page writes when fsync off, add GUC

2005-07-06 Thread Michael Paesold
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 PostgreSQL server + writes full pages to

Re: [PATCHES] Disable page writes when fsync off, add GUC

2005-07-05 Thread Bruce Momjian
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. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us

Re: [PATCHES] Disable page writes when fsync off, add GUC

2005-07-04 Thread Bruce Momjian
Peter Eisentraut wrote: > 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_p

Re: [PATCHES] Disable page writes when fsync off, add GUC

2005-07-04 Thread Peter Eisentraut
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 > f

Re: [PATCHES] Disable page writes when fsync off, add GUC

2005-07-04 Thread Stephen Frost
* Bruce Momjian (pgman@candle.pha.pa.us) 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 doesn't seem quite right to me. What happens with PITR? And Postgres crashes? While many people seriously dis

[PATCHES] Disable page writes when fsync off, add GUC

2005-07-03 Thread Bruce Momjian
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. -- Bruce Momjian