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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings