On Thu, Nov 4, 2010 at 10:27 AM, Fujii Masao <masao.fu...@gmail.com> wrote: > On Tue, Nov 2, 2010 at 10:38 PM, Dimitri Fontaine > <dimi...@2ndquadrant.fr> wrote: >> Fujii Masao <masao.fu...@gmail.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
pg_last_replay_xact_timestamp_v1.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers