Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp of the last replayed transaction - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: timestamp of the last replayed transaction
Date
Msg-id m2vd4f4zho.fsf@2ndQuadrant.fr
Whole thread Raw
In response to timestamp of the last replayed transaction  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: timestamp of the last replayed transaction
List pgsql-hackers
Tree view 
Fujii Masao <masao.fujii@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? Will it look like the
proposal in this thread:
 http://archives.postgresql.org/pgsql-hackers/2010-05/msg01209.php

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: ALTER OBJECT any_name SET SCHEMA name
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Custom code int(32|64) => text conversions out of performance reasons