Re: [COMMITTERS] pgsql: Update docs to say you need fsync to make sync rep work fast.

Lists: pgsql-committerspgsql-hackers
From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Update docs to say you need fsync to make sync rep work fast.
Date: 2011-03-22 16:37:49
Message-ID: E1Q24ab-0001FH-Jd@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers pgsql-hackers

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(-)


From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [COMMITTERS] pgsql: Update docs to say you need fsync to make sync rep work fast.
Date: 2011-04-30 16:30:51
Message-ID: 201104301630.p3UGUp905642@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers pgsql-hackers

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Simon Riggs <simon(at)2ndQuadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [COMMITTERS] pgsql: Update docs to say you need fsync to make sync rep work fast.
Date: 2011-04-30 17:39:37
Message-ID: 642.1304185177@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)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