aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2010-10-27 21:19:11 -0400
committerRobert Haas <rhaas@postgresql.org>2010-10-27 21:20:58 -0400
commit0d5deebe11818a54f79ca66e1a1d41dae0e0b52b (patch)
tree8dfc341aedc3ce4727c23b8c6d2fc0a9aa324701 /doc/src
parente6721c6e1617a0fc8b4bce8eacba8b5a381f1f21 (diff)
downloadpostgresql-0d5deebe11818a54f79ca66e1a1d41dae0e0b52b.tar.gz
postgresql-0d5deebe11818a54f79ca66e1a1d41dae0e0b52b.zip
Reorganize OS-specific details about write caching into a list.
Along the way, clarify that sdparm can be used on Linux as well as FreeBSD.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/wal.sgml71
1 files changed, 51 insertions, 20 deletions
diff --git a/doc/src/sgml/wal.sgml b/doc/src/sgml/wal.sgml
index 7b50bddd04c..e7980b386e9 100644
--- a/doc/src/sgml/wal.sgml
+++ b/doc/src/sgml/wal.sgml
@@ -69,26 +69,57 @@
</para>
<para>
- To check write caching on <productname>Linux</> use
- <command>hdparm -I</>; it is enabled if there is a <literal>*</> next
- to <literal>Write cache</>; <command>hdparm -W</> to turn off
- write caching. On <productname>FreeBSD</> use
- <application>atacontrol</>. (For SCSI disks use <ulink
- url="http://sg.danny.cz/sg/sdparm.html"><application>sdparm</></ulink>
- to turn off <literal>WCE</>.) On <productname>Solaris</> the disk
- write cache is controlled by <ulink
- url="http://www.sun.com/bigadmin/content/submitted/format_utility.jsp"><literal>format
- -e</></ulink>. (The Solaris <acronym>ZFS</> file system is safe with
- disk write-cache enabled because it issues its own disk cache flush
- commands.) On <productname>Windows</> if <varname>wal_sync_method</>
- is <literal>open_datasync</> (the default), write caching is disabled
- by unchecking <literal>My Computer\Open\{select disk
- drive}\Properties\Hardware\Properties\Policies\Enable write caching on
- the disk</>. Also on Windows, <literal>fsync</> and
- <literal>fsync_writethrough</> never do write caching. The
- <literal>fsync_writethrough</> option can also be used to disable
- write caching on <productname>MacOS X</>.
- </para>
+ These caches can typically be disabled; however, the method for doing
+ this varies by operating system and drive type:
+ </para>
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ On <productname>Linux</>, IDE drives can be queried using
+ <command>hdparm -I</command>; write caching is enabled if there is
+ a <literal>*</> next to <literal>Write cache</>. <command>hdparm -W</>
+ can be used to turn off write caching. SCSI drives can be queried
+ using <ulink url="http://sg.danny.cz/sg/sdparm.html"><application>sdparm</></ulink>.
+ for SCSI drives. Use <command>sdparm --get=WCE</command> to check
+ whether the write cache is enabled and <command>sdparm --clear=WCE</>
+ to disable it.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On <productname>FreeBSD</>, IDE drives can be queried using
+ <command>atacontrol</command>, and SCSI drives using
+ <command>sdparm</command>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On <productname>Solaris</>, the disk write cache is controlled by
+ <ulink url="http://www.sun.com/bigadmin/content/submitted/format_utility.jsp"><literal>format -e</></ulink>.
+ (The Solaris <acronym>ZFS</> file system is safe with disk write-cache
+ enabled because it issues its own disk cache flush commands.)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On <productname>Windows</>, if <varname>wal_sync_method</> is
+ <literal>open_datasync</> (the default), write caching is disabled
+ by unchecking <literal>My Computer\Open\{select disk drive}\Properties\Hardware\Properties\Policies\Enable write caching on the disk</>.
+ Alternatively, set <varname>wal_sync_method</varname> to <literal>fsync</> or <literal>fsync_writethrough</>, which never do write caching.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On <productname>MacOS X</productname>, write caching can be disabled by
+ setting <varname>wal_sync_method</> to <literal>fsync_writethrough</>.
+ </para>
+ </listitem>
+ </itemizedlist>
<para>
Many file systems that use write barriers (e.g. <acronym>ZFS</>,