Re: pg_last_xact_replay_timestamp lies

From: Anton Bushmelev <djeday84(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_last_xact_replay_timestamp lies
Date: 2015-06-15 00:04:59
Message-ID: 557E16AB.8040102@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, thank t for response, measure in bytes may bemore correct, but to
bring it to the customer? :) I think it is easier to say that the
standby database lags behind master no more than 15 minutes, than the
fact that it differs for 1 megabyte.
ps: sorry for my English

On 06/15/2015 02:57 AM, Michael Paquier wrote:
> Isn't your mistake the fact that you rely on the assumption that
> replication lag measured in terms of timestamp is a good thing while
> it should be estimated in terms of byte difference by comparing WAL
> positions between the master and its standbys?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2015-06-15 01:24:43 Re: pg_last_xact_replay_timestamp lies
Previous Message Michael Paquier 2015-06-14 23:57:37 Re: pg_last_xact_replay_timestamp lies