Skip to content

Commit 31076c8

Browse files
committed
Document that non-data journaling is a recommended mount option.
1 parent 7a567d9 commit 31076c8

File tree

1 file changed

+16
-1
lines changed

1 file changed

+16
-1
lines changed

doc/src/sgml/wal.sgml

Lines changed: 16 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/wal.sgml,v 1.53 2008/05/02 19:52:37 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/wal.sgml,v 1.54 2008/12/06 21:34:27 momjian Exp $ -->
22

33
<chapter id="wal">
44
<title>Reliability and the Write-Ahead Log</title>
@@ -135,6 +135,21 @@
135135
roll-forward recovery, also known as REDO.)
136136
</para>
137137

138+
<tip>
139+
<para>
140+
Because <acronym>WAL</acronym> restores database file
141+
contents after a crash, it is not necessary to use a
142+
journaled filesystem; in fact, journaling overhead can
143+
reduce performance. For best performance, turn off
144+
<emphasis>data</emphasis> journaling as a filesystem mount
145+
option, e.g. use <literal>data=writeback</> on Linux.
146+
Meta-data journaling (e.g. file creation and directory
147+
modification) is still desirable for faster rebooting after
148+
a crash.
149+
</para>
150+
</tip>
151+
152+
138153
<para>
139154
Using <acronym>WAL</acronym> results in a
140155
significantly reduced number of disk writes, because only the log

0 commit comments

Comments
 (0)