Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > The following patch disables WAL backup pages when fsync is off. > > This is a good idea why?
There is no need to write backup pages if fsync is off. Our TODO has: * Turn off after-change writes if fsync is disabled If fsync is off, there is no purpose in writing full pages to WAL Basically, with fsync off, you are saying you don't care about crash recovery, so why write those pages? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings