From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Joshua Tolley <eggyknap(at)gmail(dot)com> |
Cc: | pgsql-docs <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: hot standby documentation |
Date: | 2010-06-22 18:24:55 |
Message-ID: | AANLkTil6Hdy2eVTctpR4vsgUMgdfsfgeQfe7lEwR0j2T@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Tue, Jun 22, 2010 at 8:56 AM, Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:
> I'm not sure it's worth pointing out that the database might still use temp
> files. It seems an unnecessary level of detail. I realize you're probably
> putting it here because you've edited that bit out of the docs elsewhere, but
> I still think it's unnecessary detail. That said, if it has to go somewhere,
> +1 for this change.
I agree, and your guess about how it ended up there is correct. Removed.
>> - Queries executed on the standby will be correct with regard to the transactions
>> - that had been recovered at the start of the query, or start of first statement
>> - in the case of serializable transactions. In comparison with the primary,
>> - the standby returns query results that could have been obtained on the primary
>> - at some moment in the past.
>> + Queries executed on the standby will see a view of the database that
>> + existed 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 the 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 from last
> week.
I had another go at this.
> s/is depending/depends/
Fixed. See attached.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
Attachment | Content-Type | Size |
---|---|---|
hot-standby-docs-v2.patch | application/octet-stream | 10.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Tolley | 2010-06-22 23:04:03 | Re: hot standby documentation |
Previous Message | Bruce Momjian | 2010-06-22 16:20:15 | pg_ctl server log differenes on win32 |