pgsql: Update docs to say you need fsync to make sync rep work fast.

Started by Simon Riggsalmost 15 years ago3 messages
#1Simon Riggs
simon@2ndQuadrant.com

Update docs to say you need fsync to make sync rep work fast.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/6e8e7cc580665ddd43c8ca2acc6d60f345570a57

Modified Files
--------------
doc/src/sgml/high-availability.sgml | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)

#2Bruce Momjian
bruce@momjian.us
In reply to: Simon Riggs (#1)
Re: [COMMITTERS] pgsql: Update docs to say you need fsync to make sync rep work fast.

Simon Riggs wrote:

Update docs to say you need fsync to make sync rep work fast.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/6e8e7cc580665ddd43c8ca2acc6d60f345570a57

This patch added this documentation text:

+    Replies are only sent when WAL is written to disk, so setting
+    <varname>fsync</> to <literal>off</> on the standby will significantly
+    reduce performance of synchronous replication and should be avoided.

Should we also issue a warning message in the server logs for the use of
fsync=off on the standby?

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#2)
Re: Re: [COMMITTERS] pgsql: Update docs to say you need fsync to make sync rep work fast.

Bruce Momjian <bruce@momjian.us> writes:

Simon Riggs wrote:

Update docs to say you need fsync to make sync rep work fast.

Should we also issue a warning message in the server logs for the use of
fsync=off on the standby?

That patch was entirely wrong and has been reverted.

regards, tom lane