Postgres Pro
Downloads
Home   >   mailing lists

Re: How can we tell how far behind the standby is? - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: How can we tell how far behind the standby is?
Date
Msg-id AANLkTi=zK2PPrOk9KL=wdtmjfSF1i4KEPdKCyBHFHD6+@mail.gmail.com
Whole thread Raw
In response to Re: How can we tell how far behind the standby is?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: How can we tell how far behind the standby is?
List pgsql-hackers
Tree view 
On Tue, Nov 9, 2010 at 7:57 AM, Josh Berkus <josh@agliodbs.com> wrote:
>
>> The patch which I'm proposing is helpful for you?
>> http://archives.postgresql.org/pgsql-hackers/2010-11/msg00167.php
>
> Depends.  Is that the timestamp on the master (when it was synced), or
> the timestamp on the standby (when it was replayed)?  It's only helpful
> if it's the former.

It's the former. The function which I'm proposing returns the timestamp
of the last replayed commit/abort log record. That timestamp is given
when the commit/abort log record is generated in the master.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

pgsql-hackers by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: pg_ctl init doc bug
Next
From: Heikki Linnakangas
Date:
Subject: Re: CLUSTER can change t_len