DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:cc:subject:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=cQxw2h+bfJrO/i6DkQqcrR+XPnLE2ZEO35Sae4iA6nLLpCu5uiRNnxQpAgoCfO3sXS
	hjJpKNRpmQ8Ldb0hynvMe0z41bR37JjrNdHTftOUKDByeS3TuYZ+3GINO3CFUl5fus8A
	vJnk444alh9/vqslg42qsAMe+0tnMlRG2mbog=
Message-ID: <4c214166.0134e70a.3dcb.7f43@mx.google.com>
Date: Tue, 22 Jun 2010 17:04:03 -0600
From: Joshua Tolley <eggyknap@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: hot standby documentation
References: <AANLkTim808CHVifufyEjt7L-PofuxmTC2HOS2LF48se1@mail.gmail.com>
	<4c20b2ed.0134e70a.19ef.5b22@mx.google.com>
	<AANLkTil6Hdy2eVTctpR4vsgUMgdfsfgeQfe7lEwR0j2T@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="bygAmIonOAIqBxQB"
Content-Disposition: inline
In-Reply-To: <AANLkTil6Hdy2eVTctpR4vsgUMgdfsfgeQfe7lEwR0j2T@mail.gmail.com>
User-Agent: Mutt/1.5.18 (2008-05-17)


--bygAmIonOAIqBxQB
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Jun 22, 2010 at 02:24:55PM -0400, Robert Haas wrote:
> On Tue, Jun 22, 2010 at 8:56 AM, Joshua Tolley <eggyknap@gmail.com> wrote:
> >> - =A0 =A0Queries executed on the standby will be correct with regard t=
o the transactions
> >> - =A0 =A0that had been recovered at the start of the query, or start o=
f first statement
> >> - =A0 =A0in the case of serializable transactions. In comparison with =
the primary,
> >> - =A0 =A0the standby returns query results that could have been obtain=
ed on the primary
> >> - =A0 =A0at some moment in the past.
> >> + =A0 =A0Queries executed on the standby will see a view of the databa=
se that
> >> + =A0 =A0existed on the master at some moment in the past.
> >
> > Is it really that non-deterministic? /me admits not having followed that
> > discussion. Although the original version is pretty complex, it gives t=
he user
> > some feel for the particular moment in the past that their snapshot will
> > represent. If the original is incorrect, it would be nice to replace it=
 with
> > something that doesn't suggest the user might end up with a snapshot fr=
om last
> > week.
>=20
> I had another go at this.

Much better, IMO.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--bygAmIonOAIqBxQB
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkwhQWMACgkQRiRfCGf1UMP9gACeP5piT8Sf3EPzmc3OxEhJaWmI
r48AoIe6hbs3jYYHtFOQRvjPDyQia6Sx
=cIEL
-----END PGP SIGNATURE-----

--bygAmIonOAIqBxQB--