Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
Date
Msg-id 17563.1338648540@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On the other hand, if we simply say "PostgreSQL computes the
> replication delay by subtracting the time at which the WAL was
> generated, as recorded on the master, from the time at which it is
> replayed by the slave" then, hey, we still have a wart, but it's
> pretty clear what the wart is and how to fix it, and we can easily
> document that.  Again, if we could get rid of the failure modes and
> make this really water-tight, I think I'd be in favor of that, but it
> seems to me that we are in the process of expending a lot of energy
> and an even larger amount of calendar time to create a system that
> will misbehave in numerous subtle ways instead of one straightforward
> one.  I don't see that as a good trade.

Well, okay, but let's document "if you use this feature, it's incumbent
on you to make sure the master and slave clocks are synced.  We
recommend running NTP." or words to that effect.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
Next
From: Michael Nolan
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.