On Thu, Nov 4, 2010 at 10:27 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Tue, Nov 2, 2010 at 10:38 PM, Dimitri Fontaine
> <dimitri(at)2ndquadrant(dot)fr> wrote:
>> Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
>>> After 9.0 release, I've often heard that some people want to know
>>> how far transactions have been replayed in the standby in timestamp
>>> rather than LSN. So I'm thinking to include the function which returns
>>> the timestamp of the last applied transaction (i.e., commit/abort WAL
>>> record) in the core.
>>>
>>> Name: pg_last_replay_xact_timestamp (better name?)
>>> Return Type: timestamp with time zone
>>>
>>> Thought?
>>
>> How do you want to implement the tracking?
>
> I'm thinking to just expose GetLatestXTime(), i.e., XLogCtl->recoveryLastXTime.

I attached the patch.

Regards,

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

In response to

• Re: timestamp of the last replayed transaction at 2010-11-04 01:27:33 from Fujii Masao

Responses

• Re: timestamp of the last replayed transaction at 2010-11-06 00:58:31 from Robert Haas

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2010-11-05 02:59:10
	Subject: Re: plan time of MASSIVE partitioning ...
Previous:	From: Alvaro Herrera	Date: 2010-11-04 21:57:33
	Subject: Re: ALTER OBJECT any_name SET SCHEMA name