Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 1961B1337BA8
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Sat, 19 Mar 2011 16:27:17 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 85324-08
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Sat, 19 Mar 2011 19:27:07 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from shaykin.bluegap.ch (shaykin.bluegap.ch [78.46.81.73])
	by mail.postgresql.org (Postfix) with ESMTP id 731B71337BA0
	for <pgsql-hackers@postgresql.org>;
	Sat, 19 Mar 2011 16:27:06 -0300 (ADT)
Received: from [IPv6:2001:1620:f70:16:216:cbff:fe90:5caa]
	([2001:1620:f70:16:216:cbff:fe90:5caa])
	(AUTH: LOGIN markus@bluegap.ch, TLS: TLSv1/SSLv3,256bits,AES256-SHA)
	by shaykin.bluegap.ch with esmtp; Sat, 19 Mar 2011 20:27:05 +0100
	id 0000000002A08009.000000004D850389.00004745
Message-ID: <4D850388.5000401@bluegap.ch>
Date: Sat, 19 Mar 2011 20:27:04 +0100
From: Markus Wanner <markus@bluegap.ch>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.16) Gecko/20101227 Icedove/3.0.11
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: Robert Haas <robertmhaas@gmail.com>, Simon Riggs <simon@2ndquadrant.com>,
	Alvaro Herrera <alvherre@commandprompt.com>,
	Andrew Dunstan <andrew@dunslane.net>,
	Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	MARK CALLAGHAN <mdcallag@gmail.com>, Aidan Van Dyk <aidan@highrise.ca>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Re: [COMMITTERS] pgsql: Efficient	 transaction-controlled
	synchronous replication.
References: <E1PwMns-00047O-UU@gemulon.postgresql.org>
	<4D741441.2090704@dunslane.net> <1299454125.1696.6138.camel@ebony>
	<4D74896C.5030402@enterprisedb.com> <4D74DDFA.70800@dunslane.net>
	<4D74E584.7080409@enterprisedb.com> <4D74E9FA.7070202@dunslane.net>
	<AANLkTinkzJ=UrLbThZy2KeQg+SjwYqj2r0mDomMwirB7@mail.gmail.com>
	<4D74F3AE.9000802@dunslane.net> <4D74FDEC.5040406@enterprisedb.com>
	<4D74FF15.1070804@dunslane.net>
	<1299513979-sup-1987@alvh.no-ip.org> <4D832571.5030808@bluegap.ch>
	<AANLkTi=B+cWE-pQJQM=zoA9=Zr25W7zPPMFvvBe11O4E@mail.gmail.com>
	<1300457958.18619.13780.camel@ebony>
	<4D832B4D020000250003BA98@gw.wicourts.gov>
	<4D837EA2.2070205@enterprisedb.com>
	<1300465171.18619.15193.camel@ebony> <4D83B02A.5090105@bluegap.ch>
	<1300476590.18619.18115.camel@ebony>
	<AANLkTinaE8pKZ5RyVShF8ZwDF2+GGQ1bZ_Y-jfO2rLAK@mail.gmail.com>
	<4D838723020000250003BAFB@gw.wicourts.gov>
	<AANLkTin3y0VzPADjNmXYWF5t_ou7ywqHARJhaxbQ=sTR@mail.gmail.com>
	<4D838CE1020000250003BB06@gw.wicourts.gov>
In-Reply-To: <4D838CE1020000250003BB06@gw.wicourts.gov>
X-Enigmail-Version: 1.0.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.409 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: **
X-Archive-Number: 201103/1213
X-Sequence-Number: 184463

On 03/18/2011 10:48 PM, Kevin Grittner wrote:
> the least of the evils.  I guess we should document it, though, so
> nobody has a false expectation that seeing something on the replica
> means that a connection looking at the master will see something
> that current.

Agreed.  Note, however, that even if there's no such guarantee, it's
highly unlikely for a user (or application) to ever notice this during
normal operation.

Regards

Markus Wanner