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

2005-07-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > That is a question I had in my mind. I added documentation that turning > > off fsync also disables full_page_writes, but we could decouple them and > > tell people to consider disableing full_pages_writes if they turn off > > fsync, basically suggestin

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

2005-07-05 Thread Tom Lane
Bruce Momjian writes: > That is a question I had in my mind. I added documentation that turning > off fsync also disables full_page_writes, but we could decouple them and > tell people to consider disableing full_pages_writes if they turn off > fsync, basically suggesting they make the second cha

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

2005-07-04 Thread Bruce Momjian
Stephen Frost wrote: -- Start of PGP signed section. > * 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 wit