On Tue, Jul 20, 2010 at 3:13 PM, Bruce Momjian <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
