Re: Proposal: "Causal reads" mode for load balancing reads without stale data - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Proposal: "Causal reads" mode for load balancing reads without stale data
Date
Msg-id CAB7nPqR+aZ7o00zA0MV6o9mvNixPWOUvrLKW_Am8QdYp_Wo0qw@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: "Causal reads" mode for load balancing reads without stale data  (Thom Brown <thom@linux.com>)
Responses Re: Proposal: "Causal reads" mode for load balancing reads without stale data  (Thom Brown <thom@linux.com>)
Re: Proposal: "Causal reads" mode for load balancing reads without stale data  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-hackers
On Mon, Feb 22, 2016 at 9:39 AM, Thom Brown <thom@linux.com> wrote:
> On 21 February 2016 at 23:18, Thomas Munro
> <thomas.munro@enterprisedb.com> wrote:
> The replay_lag is particularly cool.  Didn't think it was possible to
> glean this information on the primary, but the timings are correct in
> my tests.
>
> +1 for this patch.  Looks like this solves the problem that
> semi-synchronous replication tries to solve, although arguably in a
> more sensible way.

Yeah, having extra logic at application layer to check if a certain
LSN position has been applied or not is doable, but if we can avoid it
that's a clear plus.

This patch has no documentation. I will try to figure out by myself
how the new parameters interact with the rest of the syncrep code
while looking at it but if we want to move on to get something
committable for 9.6 it would be good to get some documentation soon.
-- 
Michael



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [PATCH] fix DROP OPERATOR to reset links to itself on commutator and negator
Next
From: Álvaro Hernández Tortosa
Date:
Subject: PostgreSQL extension API? Documentation?