On Tue, Jul 20, 2010 at 3:13 PM, Bruce Momjian br...@momjian.us wrote:
Someone at OSCON just asked if there is a way to find the _time_ delay
between received and applied WAL. Right now
pg_last_xlog_replay_location() only reports the information in WAL
scale. It would be nice to report that in time, e.g. milliseconds.
There's probably more than one way you can define this. See, for
example, previous discussions of max_standby_delay.
Because an idle master will not generate WAL, I don't think there is a
way to report the time delay in receiving WAL.
You could certainly come up with a sensible definition for this,
though there are also nonsensical ones.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
